PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

SQR: Error when select BigInt datatype

edited Feb 3, 2015 6:54AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 7 commentsAnswered

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center