SQR: Error when select BigInt datatype
Hi,
I am receiving the following error when attempting to select a bigint datatype from a db2 table.
(SQR 1305) CMPSQL: Unknown data type in database: 492.
I've trimmed down my SQR to isolate the issue and the code is (column_name is a bigint in db2):
begin-select
column_name
from table_name
end-select
The confusing part is that this code runs from my Windows SQR, however not from Unix SQR. I need it to work in the Unix environment.
Thanks.