PowerCenter
- PowerCenter 10.5.1
- All Products
TO_BIGINT(value[,flag] )
Argument
| Required/
Optional
| Description
|
---|---|---|
value
| Required
| String or numeric datatype. Passes the value you want to convert to a bigint value. 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_BIGINT truncates the decimal portion when the flag is TRUE or a number other than 0.
TO_BIGINT rounds the value to the nearest integer if the flag is FALSE or 0 or if you omit this argument.
The flag is not set by default.
|
TO_BIGINT( IN_TAX, TRUE )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TO_BIGINT( IN_TAX )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|