Making changes

The note lines (=NOTE=) at the top of the SQL Edit session indicate whether you can make changes to the SQL statement. When data is displayed in a File Manager/Db2 editor session, you cannot change the SQL statement without first ending the current editor session. To interactively test and change SQL statements, use Prototyping: Enter (option 4.3), or use the Re-edit template option on the Db2® View or Db2® Edit panel.

You can use FM/Db2 reference numbers as abbreviations for the column names.

When you exit the SQL Edit session by pressing the Exit function key (F3), FM/Db2 converts FM/Db2 reference numbers to the corresponding Db2® column name, and validates the statement. If the validation fails, FM/Db2 redisplays the SQL statement with an error message.

Note:
  1. You cannot change any part of the SQL statement before the WHERE keyword. This includes the list of columns in the SELECT clause (see the following note item).
  2. All columns in the table are included in the SELECT clause (following the SELECT keyword) of the SQL statement, even if you have edited the template to deselect some columns. If you deselect a column, it causes FM/Db2 not to display that column; it does not affect the SQL command used by FM/Db2 to retrieve the data from Db2®.
  3. The maximum length for the WHERE clause that can be specified in the ISPF editor session displayed by the SQL command is 32767 characters.

Related tasks

Related references