SQL primary command

The SQL primary command displays the SQL SELECT statement for the object you are processing. You can view the SELECT statement and save it in an ISPF data set for future reference.

When you enter the SQL command, the SELECT statement is presented in a standard ISPF EDIT panel. You can save the statement using the ISPF CREATE command. To do this:

  1. On the command line, type CREATE.
  2. In the prefix area of the top line of the SELECT statement, type c9999.
  3. Press Enter.

    You are asked to supply the data set and member name in which to save the SELECT statement. If the data set does not exist, you are asked to specify the allocation attributes to create it. You cannot use the attributes of the temporary data set displayed; you must provide the required attributes yourself.

Note: When you start an editor session from the function entry panel, the SELECT clause in the SQL statement includes every column of the table, even if you have edited the template and deselected one or more columns.

When you are working with SQL statements, any changes you make to the command in the ISPF Edit session are not preserved when you return to the prototyper.

Syntax


1 SQL

Availability

Related tasks