Skip to Content

Default language.

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

DIGITS

The DIGITS function returns a character string representation of the absolute value of a number.

DIGITS.png

numericExpression must return a value that is a SMALLINT, BIGINT, INTEGER, or DECIMAL built-in numeric data type.

The following table describes the output lengths for the BIGINT function:

Data type

Output length

SMALLINT

5

BIGINT

19

INTEGER

10

DECIMAL

p if the argument is a decimal with a precision of p


Warning

Important

If the argument can be null, the result can be null; if the 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*

BMC AMI Unload for Db2 12.1