DB2 10.01 for ZOS
One program has a query that joins table A with table B:
from table-a a, table-b b
where a.id = int(b.id)
a.id is INTEGER
b.id is SMALLINT
It displays different results if a remove INT function. Is this function necessary?
What does it do?
I searched for this function but I didn't find info for DB2 for ZOS 10. Only found:
https://publib.boulder.ibm.com/iseries/ ... HDRINTFUNC
http://www-01.ibm.com/support/knowledge ... -10-3-2-69
The INTEGER (or INT) function returns an integer representation of:
A string representation of a number
A date value
A time value