What is NTE ?

Document ID : KB000100953
Last Modified Date : 06/07/2018
Show Technical Document Details
Question:
What is NTE?
Environment:
z/os, CA Datacom/DB 15.1 
Answer:
NTE stands for  NESTED TABLE EXPRESSION 

NTE is a  latest SQL enhancement ,

see following link from docops:
https://docops.ca.com/ca-datacom/15-1/en/using/using-sql/nested-table-expression-nte
 
Additional Information:
Note that:
Currently confirmed  APAR #: SO01886  (Title: NESTED TABLE EXPRESSION ENHANCEMENT) is required.

Note that:
APAR #: SO04034 also allows a Nested Table Expression (NTE) to use merge join, even when SQL_OPTIMIZATION_LEVEL is 1.