PowerCenter
- PowerCenter 10.5.1
- All Products
TO_INTEGER(value[,flag] )
Argument
| Required/
Optional
| Description
|
---|---|---|
value
| Required
| String or numeric datatype. Passes the value you want to convert to an integer. You can enter any valid transformation expression.
|
flag
| Optional
| Specifies whether to truncate or round the decimal portion. The flag must be an integer literal or the constants TRUE or FALSE.
TO_INTEGER truncates the decimal portion when the flag is TRUE or a number other than 0.
TO_INTEGER rounds the value to the nearest integer if the flag is FALSE or 0 or if you omit this argument.
|
TO_INTEGER( IN_TAX, TRUE )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TO_INTEGER( IN_TAX, FALSE)
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|