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 ALTER and BMC AMI Change Manager for Db2 13.1.

Nonprintable or nonviewable characters

You must specify nonprintable and nonviewable characters (such as null and control characters) in limit keys, view text, trigger text, or check constraint text in an external hexadecimal format.

These characters are not indicated in literal strings. For example, the EBCDIC string '2 1' does not indicate that the second character is null; the string appears to be blank. The string should be specified as X'F200F1'.


Hexadecimal formats for common nonprintable or nonviewable characters.

Character

Hexadecimal format

Null

X'00'

Horizontal tab ('HT')

X'05'

Form feed

X'0C'

Carriage return

X'0D'

New line ('NL')

X'15'

Line feed ('LF')

X'25'

Note the following items about nonviewable characters:

  • If a value in a limit key field in a partitioned index contains a nonviewable character, you cannot edit that value in the Specification component.
  • If null characters exist in the internal format of a value for an object, the Baseline, Import, and Compare components issue a warning message.

Related topic

Customizing-after-installation



 

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