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

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box. Note: To report a problem or question about the product software, do not use this form. Instead, go to the IBM Software Support site.