IBM Mainframe Forum

Hi,

If any one please help me with SQL code 0000094K. (-942 i think)

Thanks.

There does not appear to be a -942. There is a -947 and -948. What message went with it?

No SQL code was 94k / -942 only. I got it in a sql query in COBOL so no message with it.

There is always a message associated with a SQL code. Use DSNTIAR to generate and format it.

Sorry, it was a error code in Oracal which means ' tried to execute a SQL statement that references a table or view that either does not exist, that you do not have access to, or that belongs to another schema and you didn't reference the table by the schema name.'

Thanks a lot for the help

once in a while the TS is right
k is the zoned representation of a -2,

whether a -942 is a valid DB2 code it' s a different can of worms

here is a table with the conversions



the x'C0'/x'D0' might display differently if the code page used on the system is different
the display of some chars depending on the code page ha and will alway be a murky issue

As the TS finally got around to mentioning, -942 is an Oracal (sic) SQL code, not a DB2 one.