Default language.

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 BMC AMI Check for Db2 13.1.

VARCHAR

The VARCHAR function converts a fixed or varying length character string into a variable-length character string.

VARCHAR.png

The arguments are defined as follows:

stringExpression

stringExpression is a fixed or variable-length character string.

If stringExpression length exceeds its maximum length, the product generates an error message and terminates the unit of work (UOW).

length

length is an integer constant of the maximum length of the result. If the value of length is shorter than the length of stringExpression, then the function truncates the result to the specified length, without warning.

Important

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


Related topics

Functions-that-the-BMC-AMI-Utilities-SQL-language-supports

Features-that-the-BMC-AMI-Utilities-SQL-language-supports

 

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