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 Unload for Db2 13.1.

STRIP


The STRIP function removes blanks or other characters from the end, the beginning, or both ends of a string expression. The data type of the result is the same as the string expression, but in a different format.

(PTF BQU2361 applied) The STRIP and TRIM functions behave in much the same way and can be used in all defined contexts for BMC AMI Utilities. For more information on the TRIM function, see TRIM.

Arguments

The arguments are defined as follows:

stringExpression

Must be one of the following data types:

  • CHAR
  • VARCHAR

(PTF BQU2361 applied)

  • GRAPHIC
  • VARGRAPHIC
  • BINARY
  • VARBINARY

direction

(Optional) Determines whether characters are removed from the end (TRAILING), the beginning (LEADING), or from both (BOTH) directions of the stringExpressionMust be one of the following values:

  • (Default) Both
  • Leading
  • Trailing

trimCharacter

(Optional) A single single-byte character set (SBCS) character (by default a blank).

(PTF BQU2361 applied) A single SBCS or double-byte character set (DBCS) character constant in the same data type as stringExpression

When you specify a form other than UX", BX", or X", the utility assumes that the encoding scheme is EBCDIC and converts the encoding scheme of stringExpression. If you omit the trim character constant, the default is the padding character of stringExpression.

The trim character data type must match the string expression data type. Otherwise the function will be rejected with an error.

Important

If either the stringExpression or the trimCharacter is null, the result of the function is null.

Results

The length attribute of the result is the same as the length attribute of the string expression. The actual length of the result is the length of the string expression minus the number of characters removed. If all of the characters are removed, the result is an empty string.

 

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