What is NTE ?
search cancel

What is NTE ?

book

Article ID: 100953

calendar_today

Updated On:

Products

Datacom DATACOM - AD

Issue/Introduction

What is NTE?

Resolution

NTE stands for  NESTED TABLE EXPRESSION 

NTE is a  latest SQL enhancement ,

See this section of the documentation:



 

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.