EXPLAIN OPTIONS

Document ID : KB000098873
Last Modified Date : 01/06/2018
Show Technical Document Details
Issue:
Navigating from R/INCOMPTD SQL Incompatibilities (IFCID 376) panel, after putting E for Explain next to a Plan what option to choose from the following Explain Menu Options?
Explain Menu Options
_ 1 Display EXPLAIN data for packages/DBRMs
2 EDIT/EXPLAIN SQL statement from a data set
3 EDIT/EXPLAIN SQL statement entered in ISPF EDIT
4 EDIT/EXPLAIN SQL statement entered on SYSVDB2 panel
5 Manage EXPLAIN environment

 
Resolution:
Display EXPLAIN data for packages/DBRMs because this was about a program.