SQLCODE 00000031}

apandey · New User Joined: 31 Aug 2009 Posts: 73 Location: Mumbai

Hi,
Can anyone pls let me value what is value of SQLCODE "00000031}"
I know "}" is EBCDIC code, but i am not able to find its actual value?

Is it -310 ? (It's a guess)

Akatsukami · Posted: Tue May 24, 2011 5:12 pm

apandey · New User Joined: 31 Aug 2009 Posts: 73 Location: Mumbai

Can anyone pls provide list of EBCDIC code and its actual value ?
Actually I searched in this forum, few EBCDIC codes and its value is given but I was not able to find value "}" , I tried to goole it and then tried to "QW" in mainframe but not found the answer. Finally I posted.
I may be right but as i said it was a guess. I m still not sure with my guess.

don.leahy · Posted: Tue May 24, 2011 5:30 pm

What is the hex value of the "31}" SQLCODE? Once you look at this, the meaning will be obvious.

dbzTHEdinosauer · Posted: Tue May 24, 2011 5:32 pm

trouble searching?

ibmmainframes.com/viewtopic.php?t=40254

apandey · New User Joined: 31 Aug 2009 Posts: 73 Location: Mumbai

Thanks everyone for quick response.

apandey · New User Joined: 31 Aug 2009 Posts: 73 Location: Mumbai

Hi All,

1 more issue i am getting, I have a DB2 Insert statement, in which I was getting SQLcode -310.
Its description is (DECIMAL HOST VARIABLE OR PARAMETER number CONTAINS NON-DECIMAL DATA).
So I tried to find out all numeric fields which I am inserting in the table.
I found those numeric field and commented out in INSERT statement.
But still I am getting same Sqlcode -310. There are around 40 fields which i m inerting in my table to INSERT statement.

Is there any way to find out, on which exact field it is giving SQLCODE -310 ?

dbzTHEdinosauer · Posted: Mon May 30, 2011 3:24 pm

a professional would use a CALL to DSNTIAR to expand the SQLCA after receiving a negative SQLCODE.

in the expansion of the -310 SQLCODE, it provids the parameter number of the parm causing the error.

apandey · New User Joined: 31 Aug 2009 Posts: 73 Location: Mumbai

Hi dbzTHEdinosauer,

Sorry I have seen this in compile listing of program.
but i don't know how to expand CALL to DSNTIAR
or where to see the fields in CALL to DSNTIAR.

Can you pls help.
Thanks.

dbzTHEdinosauer · Posted: Mon May 30, 2011 4:05 pm

Handling SQL error return codes in COBOL

Displaying SQLCA fields by calling DSNTIAR