SQL code 0000094K



Post anything related to mainframes (IBM & UNISYS) if not fit in any of the above categories

SQL code 0000094K

Postby nishantbisht » Wed Oct 26, 2016 4:32 pm

Hi,

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

Thanks.
nishantbisht
 
Posts: 3
Joined: Tue Oct 04, 2016 3:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQL code 0000094K

 

Re: SQL code 0000094K

Postby NicC » Wed Oct 26, 2016 4:53 pm

There does not appear to be a -942. There is a -947 and -948. What message went with it?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2676
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 102 times

Re: SQL code 0000094K

Postby nishantbisht » Wed Oct 26, 2016 5:16 pm

No SQL code was 94k / -942 only. I got it in a sql query in COBOL so no message with it.
nishantbisht
 
Posts: 3
Joined: Tue Oct 04, 2016 3:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQL code 0000094K

Postby Akatsukami » Wed Oct 26, 2016 5:35 pm

There is always a message associated with a SQL code. Use DSNTIAR to generate and format it.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1049
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: SQL code 0000094K

Postby nishantbisht » Wed Oct 26, 2016 5:51 pm

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
nishantbisht
 
Posts: 3
Joined: Tue Oct 04, 2016 3:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQL code 0000094K

Postby enrico-sorichetti » Wed Oct 26, 2016 6:08 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2603
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 127 times

Re: SQL code 0000094K

Postby Akatsukami » Wed Oct 26, 2016 6:12 pm

As the TS finally got around to mentioning, -942 is an Oracal (sic) SQL code, not a DB2 one.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1049
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to All other Mainframe Topics

 


  • Related topics
    Replies
    Views
    Last post