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.

SUBSTR


SUBSTR function returns a portion of a string of the same data type as stringExpression.

SUBSTR.png

The arguments are defined as follows:

stringExpression

stringExpression must be one of the following data types:

  • CHAR
  • VARCHAR
  • GRAPHIC
  • VARGRAPHIC

startIntegerExpression

startIntegerExpression specifies which position in stringExpression use as the first character of the substring. The value of the startIntegerExpression must be between 1 and the length attribute of stringExpression. (The length attribute of a varying-length string is its maximum length.) A value of 1 indicates that the first character of the substring is the first character of stringExpression.

lengthIntegerExpression

Specifying lengthIntegerExpression is optional. If you include it, the utility pads the substring on the right with the necessary number of characters to satisfy the length criteria. The product uses the pad character for the current table.

The varying attribute of the result substring depends on lengthIntegerExpression. If you omit lengthIntegerExpression, the varying attribute of the substring is the same as stringExpression, and the length of the result substring is the same as the source string.

If lengthIntegerExpression is a constant with a value of 255 or less, the resulting substring is a fixed character or graphic string of the specified length. If lengthIntegerExpression is not a constant the resulting substring is a varying character or graphic string with the same maximum length as stringExpression.


Important

If any of the arguments can be null, the result can be null; if any argument value is null, the result is the null value.



 

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