Skip to Content

Default language.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Reorg for Db2 13.1.

NULL/NOT NULL predicate

If you are using the NULL/NOT NULL predicate, you must ensure that the underlying column has the NULL attribute defined.

Information
Example

The following expression causes a syntax error if column 'COL1' was defined as NOT NULL:

COL1 IS NOT NULL

SQL statements that are ordinarily coded using the IBM MOD function must instead use the operator // (double forward slash ) as a substitute. 

Information
Example

Instead of entering the following WHERE clause: 

MOD(DAYS(CURRENT DATE), 2) = 1

enter 

WHERE DAYS(CURRENT DATE) // 2 = 1. 

Related topics

Comparisons

BMC-AMI-Utilities-SQL-language

BMC-AMI-Utilities-SQL-language-keywords

 

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

BMC AMI Reorg for Db2 12.1