DB2 Scalar functions - RTRIM (SYSFUN schema)


Volta a página anterior

Volta ao Menu das scalar functions

Volta ao Menu Principal


Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

RTRIM (SYSFUN schema)

Returns the characters of the argument with trailing blanks removed.

RTRIM(expression)

The schema is SYSFUN.

expression
The expression can be of any built-in character string data type.
For a VARCHAR the maximum length is 4 000 bytes and for a CLOB the maximum length is 1 048 576 bytes.

The result of the function is:

  • VARCHAR(4000) if is VARCHAR (not exceeding 4 000 bytes) or CHAR
  • CLOB(1M) if expression is CLOB or LONG VARCHAR

The result can be null; if expression< is null, the result is the null.



© Copyright IBM Corp.