Long WHERE clauses

You can use the FM/Db2 SQL Edit session to enter long WHERE clauses (subject to any limits imposed by your host Db2® system). See the DB2 for z/OS SQL Reference.

If the SQL expression is too large to be displayed in the Row Selection Criteria section of the Column Selection/Edit panel, FM/Db2 displays as much of the expression as possible. In this situation, if you make any changes to the expression on the Column Selection/Edit panel, FM/Db2 displays an ISPF Edit session containing the complete SQL expression.

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 references

• Column Selection/Edit panel