View previous topic :: View next topic
|
Author |
Message |
rohin
New User
Joined: 29 Apr 2005 Posts: 21 Location: Gurgaon, India
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
the_gautam
Active User
Joined: 05 Jun 2005 Posts: 165 Location: Bangalore
|
|
|
|
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 |
|
|
|