| View previous topic :: View next topic |
| Author |
Message |
Siddheart22
Beginner
Joined: 11 Apr 2005
Posts: 42
Topics: 19
Location: India
|
 Posted: Fri Jun 09, 2006 6:10 am Post subject: Moving SQLCODE ie: s9(09) comp to s9(10) |
 |
|
hi,
In many existing Stored Procedures in my application,
the SQLCODE is moved into a var that is s9(10).
When I check the value of this o/p variable on SP Builder, it is 80N or 80 L etc.
Can someone help me with the conversion table.
I would like to undertsand what is meant by 80N , 80L
Thanks, |
|
| Back to top |
|
 |
acevedo
Beginner
Joined: 03 Dec 2002
Posts: 127
Topics: 0
Location: Europe
|
| Posted: Fri Jun 09, 2006 6:56 am Post subject: |
|
|
type 80N in any edit member and then set HEX ON and you'll see
80N
FFD
805
now, try the same with 80L... |
|
| Back to top |
|
|
shekar123
Advanced
Joined: 22 Jul 2005
Posts: 528
Topics: 90
Location: Bangalore India
|
| Posted: Fri Jun 09, 2006 7:33 am Post subject: |
|
|
Siddheart22,
Please use this sheet to interpret.
| 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 = } *
**********************************************************************
+---------------------------------------------------------------+
| Last Character will be | |
| represented as below for.. | 0 1 2 3 4 5 6 7 8 9 |
+---------------------------------------------------------------+
| If the Number is +ve | { A B C D E F G H I |
+---------------------------------------------------------------+
| If the Number is -ve | } J K L M N O P Q R |
+---------------------------------------------------------------+
80N would be SQL CODE -805
80L would be SQL CODE -803 |
_________________
Shekar
Grow Technically |
|
| Back to top |
|
|
programmer1
Beginner
Joined: 18 Feb 2004
Posts: 138
Topics: 14
|
| Posted: Sun Jun 11, 2006 2:14 am Post subject: |
|
|
You may also want to change the description of the field receving the SQLCODE. If its declared as PIC + 9(4), it will automatically show the correct results.
_________________
Regards,
Programmer |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
