What is NTE ?

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• Xpertware

Issue/Introduction

What is NTE?

Environment

z/os, CA Datacom/DB 15.1 

Resolution

NTE stands for  NESTED TABLE EXPRESSION 

NTE is a  latest SQL enhancement ,

See following link from documentation:

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-datacom/15-1/using/using-sql/using-nested-table-expressions-nte.html

 

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.