SQL Reference

INTEGER

>>-+-INTEGER-+--(----+-numeric-expression---+--)---------------><
   '-INT-----'       '-character-expression-'
 

The schema is SYSIBM.

The INTEGER function returns an integer representation of a number or character string in the form of an integer constant.

numeric-expression

An expression that returns a value of any built-in numeric data type.

If the argument is a numeric-expression, the result is the same number that would occur if the argument were assigned to a large integer column or variable. If the whole part of the argument is not within the range of integers, an error occurs. The decimal part of the argument is truncated if present.

character-expression

An expression that returns a character string value of length not greater than the maximum length of a character constant. Leading and trailing blanks are eliminated and the resulting string must conform to the rules for forming an SQL integer constant (SQLSTATE 22018). The character string cannot be a long string.

If the argument is a character-expression, the result is the same number that would occur if the corresponding integer constant were assigned to a large integer column or variable.

The result of the function is a large integer. If the argument can be null, the result can be null; if the argument is null, the result is the null value.

Examples:

• Using the EMPLOYEE table, select a list containing salary (SALARY) divided by education level (EDLEVEL). Truncate any decimal in the calculation. The list should also contain the values used in the calculation and employee number (EMPNO). The list should be in descending order of the calculated value.

    SELECT INTEGER (SALARY / EDLEVEL), SALARY, EDLEVEL, EMPNO
      FROM EMPLOYEE
      ORDER BY 1 DESC
  

• Using the EMPLOYEE table, select the EMPNO column in integer form for further processing in the application.

    SELECT INTEGER(EMPNO) FROM EMPLOYEE