SQL edit

The SQL Edit screen shown in the following figure is an ISPF EDIT session on the SQL source generated by File-AID/RDX using the values you specified on the Selection Criteria screen. It is displayed when you enter the SQL command in the COMMAND field on the Selection Criteria screen and press Enter.

Only the WHERE clause of the SQL statement is displayed as it is the only part of the SQL statement that can be modified for selection criteria.

Use this screen to view or modify SQL source. This can occur when you change the SQL source in the extract criteria file from outside of File-AID/RDX.

SQL Edit Screen

 EDIT - File-AID/RDX Generated SQL --------------------------- COLUMNS 000 000
 COMMAND ===>                                                  SCROLL ===> CSR
 *NOTE*
 *NOTE* All Columns will be extracted FROM FRSAMP.PART_TABLE
 *NOTE*
 ****** ***************************** TOP OF DATA ******************************
 000001   WHERE PART_NUMBER > 'PP0000'         
 000002          OR PART_NUMBER = 'BB4545'     
 000003          AND EFFECT_DATE = CURRENT_DATE
 ****** *************************** BOTTOM OF DATA *****************************


The body of the SQL Edit screen consists of a scrollable data editing area.

Line Commands

ISPF edit line commands are valid on the panel.

Primary Commands

ISPF primary commands are valid on this panel.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*