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.

INTEGER or INT

The INTEGER function returns an integer representation of a number. The argument can be either a string expression or a numeric expression.

INTEGER.png

The arguments are defined as follows:

numericExpression

numericExpression is converted to an integer from one of the following numerical data types:

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

The numeric expression is not rounded before conversion and any fractional part is truncated. If the result exceeds the allowable values for an integer, an overflow condition will occur. The valid range is -2147483648 through 2147483647.

Important

If the argument can be null, the result can be null; if the argument value is null, the result is the null value. If the argument is a constant, it must adhere to integer value rules. Specifying INT(1.5) causes an error because 1.5 is not an integer.

stringExpression

If the argument is a string expression, it can be in any external numerical format. It is first converted to its corresponding format, and then converted to an integer. If the CCSID of the string is not in EBCDIC encoding scheme, CCSID is cast to EBCDIC before conversion takes place.


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*