Default language.

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

BIGINT

The BIGINT function returns a very large integer representation of a number.

BIGINT.png

numericExpression

The numericExpression is converted to a big integer data type from one of the following numerical data types:

  • SMALLINT
  • INTEGER
  • BIGINT
  • FLOAT
  • REAL
  • DECIMAL
  • DECFLOAT

The numerical expression is not rounded before conversion and any fractional part is truncated. If the result exceeds the allowable values for a BIGINT, an overflow condition occurs. The valid range is - 9223372036854775808 through 9223372036854775807 .

stringExpression

The stringExpression can be in any external numerical format. It is first converted to its corresponding format, and then converted to BIGINT. If the CCSID of the string is not in the EBCDIC encoding scheme, the CCSID is cast to EBCDIC CCSID(37) before conversion takes place.

Important

If a constant, then the argument must adhere to integer value rules. Specifying BIGINT(1.5) causes an error since 1.5 is not an integer.

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