IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQLCODE -922 displayed in spool as SQLCODE 92K


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rohin

New User


Joined: 29 Apr 2005
Posts: 21
Location: Gurgaon, India

PostPosted: Tue Apr 22, 2008 11:58 am
Reply with quote

Hi,

On running a query program in CICS environment, I am getting SQLCODE=-922. But it is getting displayed in spool as SQLCODE=92K.

I remember I read it somewhere about usage of char J & K to denote certain numbers, but do not remember it clearly. Could somebody please clarify?

Thanks,
Rohin
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Apr 22, 2008 12:02 pm
Reply with quote

Code:

*************************************************************
*  VALUES:                                                           *
*      1 = A          -1 = J     NUMBER    REPRESENTATION *
*      2 = B          -2 = K                  10        00000001{    *
*      3 = C          -3 = L                 105        00000010E    *
*      4 = D          -4 = M                   0        00000000{    *
*      5 = E          -5 = N                -234        00000023M    *
*      6 = F          -6 = O                 -30        00000003}    *
*      7 = G          -7 = P                                         *
*      8 = H          -8 = Q                                         *
*      9 = I          -9 = R                                         *
*      0 = {          -0 = }                                         *
*************************************************************

Back to top
View user's profile Send private message
the_gautam

Active User


Joined: 05 Jun 2005
Posts: 165
Location: Bangalore

PostPosted: Tue Apr 22, 2008 1:16 pm
Reply with quote

as dbzTHEdinosauer stated, you are getting the correct thing only.
if you want to get it in the proper format, move the sqlcode to a PIC -999 dataitem and display it.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Search string in job at regular Spool... CLIST & REXX 0
No new posts Capturing logs from spool dd JCL & VSAM 6
No new posts SQLCODE = -122 while using the scalar... DB2 4
No new posts No sysout coming in spool JCL & VSAM 4
No new posts SQLCODE = -16002 when using XMLEXISTS DB2 1
Search our Forums:

Back to Top