Default language.

Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Limited supportBMC 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.

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. 

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*