|
|
| Author |
Message |
rohin
New User
Joined: 29 Apr 2005
Posts: 11
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 |
|
 |
References
|
 Posted: Tue Apr 22, 2008 11:58 am Post subject: Re: SQLCODE=-922 displayed in spool as SQLCODE=92K |
|
|
|
|
dbzTHEdinosauer
Senior Member
Joined: 20 Oct 2006
Posts: 1343
Location: germany
|
|
|
|
| Code: |
**********************************************************************
* VALUES: *
* 1 = A -1 = J EXAMPLES: 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: 169
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 |
|
|
|
|
