Page 1 of 1

SQL code 0000094K

PostPosted: Wed Oct 26, 2016 4:32 pm
by nishantbisht
Hi,

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

Thanks.

Re: SQL code 0000094K

PostPosted: Wed Oct 26, 2016 4:53 pm
by NicC
There does not appear to be a -942. There is a -947 and -948. What message went with it?

Re: SQL code 0000094K

PostPosted: Wed Oct 26, 2016 5:16 pm
by nishantbisht
No SQL code was 94k / -942 only. I got it in a sql query in COBOL so no message with it.

Re: SQL code 0000094K

PostPosted: Wed Oct 26, 2016 5:35 pm
by Akatsukami
There is always a message associated with a SQL code. Use DSNTIAR to generate and format it.

Re: SQL code 0000094K

PostPosted: Wed Oct 26, 2016 5:51 pm
by nishantbisht
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

Re: SQL code 0000094K

PostPosted: Wed Oct 26, 2016 6:08 pm
by enrico-sorichetti
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

Digit   Hex     Binary      Display
+0      X'C0'   B'11000000' {   
+1      X'C1'   B'11000001' A   
+2      X'C2'   B'11000010' B   
+3      X'C3'   B'11000011' C   
+4      X'C4'   B'11000100' D   
+5      X'C5'   B'11000101' E   
+6      X'C6'   B'11000110' F   
+7      X'C7'   B'11000111' G   
+8      X'C8'   B'11001000' H   
+9      X'C9'   B'11001001' I   
-0      X'D0'   B'11010000' }   
-1      X'D1'   B'11010001' J   
-2      X'D2'   B'11010010' K   
-3      X'D3'   B'11010011' L   
-4      X'D4'   B'11010100' M   
-5      X'D5'   B'11010101' N   
-6      X'D6'   B'11010110' O   
-7      X'D7'   B'11010111' P   
-8      X'D8'   B'11010100' Q   
-9      X'D9'   B'11011001' R   
 


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

Re: SQL code 0000094K

PostPosted: Wed Oct 26, 2016 6:12 pm
by Akatsukami
As the TS finally got around to mentioning, -942 is an Oracal (sic) SQL code, not a DB2 one.