|
ISINT |
Scroll |
The ISINT (Is Integer) function determines whether or not a value is a valid integer. If the value is an integer, a true (1) is returned. Otherwise, a false (0) is returned.
Category
Boolean
Syntax
ISINT(value)
Parameter Descriptions
value - This parameter specifies the value to be tested to determine whether or not it is a valid integer. The value to be tested can be a field from a source datastore, a variable or the result of another Function. 1 | 0 Indicates whether a TRUE (1) or FALSE (0) was returned from the ISINT function.
Example
Determine whether or not an employee’s type code (TYPE_CODE) is a valid integer number. If TYPE_CODE contains a valid integer number, map it to target field TYPE_CODE. Otherwise, map a constant of spaces (' ') to the target field.
IF ISINT (TYPE_CODE) = 1
{
TGT_DS.TYPE_CODE = TYPE_CODE)
}
ELSE
{
TGT_DS.TYPE_CODE' = ' ')
}
