View previous topic :: View next topic
|
Author |
Message |
Prajesh_v_p
Active User
Joined: 24 May 2006 Posts: 133 Location: India
|
|
|
|
Hi all,
I am doing an muti row fetch from a table. But I am getting an sqlcode of +354. I have done cross checking of the table mapping and DCLGEN array mapping and it is exactly same except for a VARCHAR field, for which we have to add the lenth field also, as show below.
Code: |
05 MY-FIELD OCCURS 100 TIMES.
49 MY-FIELD-LENGTH PIC S9(04) COMP.
49 MY-FIELD-DATA PIC X(255). |
Variable MY-FIELD is used in the fetch clause. Table column is declared as VARCHAR 255. Can anybody share some info, if you have come across any similar situations?
If we need to do 'GET DIAGNOSTICS', Can any body give me some ref link for the same.
Thanks in advance! |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
have you investigated SQLERRCD(3)? |
|
Back to top |
|
|
rpuhlman
New User
Joined: 11 Jun 2007 Posts: 80 Location: Columbus, Ohio
|
|
Back to top |
|
|
|