RTRIM scalar function

The RTRIM function removes any of the characters contained in a trim expression from the end of a string expression. The character search compares the binary representation of each character (consisting of one or more bytes) in the trim expression to the binary representation of each character (consisting of one or more bytes) at the end of the string expression. The database collation does not affect the search. If the string expression is defined as FOR BIT DATA or is a binary type, the search compares each byte in the trim expression to the byte at the end of the string expression.

The schema is SYSIBM. (The SYSFUN version of this function that uses a single parameter continues to be available with support for CLOB arguments.)

string-expression

An expression that specifies the source string.

• If only one argument is specified, the expression must return a built-in character string, graphic string, binary string, CLOB or DBCLOB value, , numeric value, or datetime value. If the value is:
  • Not a CHAR, VARCHAR, GRAPHIC, VARGRAPHIC, BINARY, VARBINARY, or DBCLOB value, it is implicitly cast to VARCHAR before the function is evaluated
  • A DBCLOB value, it is implicitly cast to VARGRAPHIC before the function is evaluated
  The data type of the string expression cannot be BLOB (SQLSTATE 42815).
• If both arguments are specified, the expression must return a built-in character string, numeric value, or datetime value. If the data type of the string-expression value is not a string data type, the value is implicitly cast to VARCHAR before the function is evaluated. The actual length of a CLOB value is limited to the maximum size of a VARCHAR data type (SQLSTATE 22001). The actual length of a BLOB value is limited to the maximum size of a VARBINARY data type (SQLSTATE 22001). The actual length of a DBCLOB value is limited to the maximum size of a VARGRAPHIC data type (SQLSTATE 22001).

trim-expression

An expression that specifies the characters that are being removed from the end of a string-expression. The expression must be a value that is a built-in string, numeric, or datetime data type.

• If the data type of the trim-expression is not a string, then the value is implicitly cast to VARCHAR before the function is evaluated.
• If the data type of the trim-expression is a CLOB, then the actual length of the value is limited to the maximum size of a VARCHAR (SQLSTATE 22001).
• If the data type of the trim-expression is a DBCLOB, then the actual length of the value is limited to the maximum size of a VARGRAPHIC (SQLSTATE 22001).
• If the data type of trim-expression is a BLOB, then the actual length of the value is limited to the maximum size of a VARBINARY (SQLSTATE 22001).
• If the string-expression is not defined as FOR BIT DATA, then the trim-expression cannot be defined as FOR BIT DATA (SQLSTATE 42815).

When a trim-expression is not specified, the data type of the string-expression determines the default value used:

• A double byte blank if the string-expression is a graphic string in a DBCS or EUC database
• A UCS-2 blank if the string-expression is a graphic string in a Unicode database
• A value of X'20' if the string-expression is a FOR BIT DATA string
• A value of X'00' if the string-expression is a binary string
• A single-byte blank for all other cases

The string-expression and trim-expression values must have compatible data types. If one of these arguments is a FOR BIT DATA character string, the other argument cannot be a graphic string (SQLSTATE 42846). A combination of character string and graphic string arguments can be used only in a Unicode database (SQLSTATE 42815).