Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQLCODE 00000031}

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
apandey

New User


Joined: 31 Aug 2009
Posts: 73
Location: Mumbai

PostPosted: Tue May 24, 2011 5:10 pm    Post subject: SQLCODE 00000031}
Reply with quote

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)
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1738
Location: Bloomington, IL

PostPosted: Tue May 24, 2011 5:12 pm    Post subject: Re: SQLCODE 00000031}
Reply with quote

apandey wrote:
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)

Yes.
Back to top
View user's profile Send private message
apandey

New User


Joined: 31 Aug 2009
Posts: 73
Location: Mumbai

PostPosted: Tue May 24, 2011 5:18 pm    Post subject: Reply to: SQLCODE 00000031}
Reply with quote

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.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Tue May 24, 2011 5:30 pm    Post subject:
Reply with quote

What is the hex value of the "31}" SQLCODE? Once you look at this, the meaning will be obvious.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue May 24, 2011 5:32 pm    Post subject:
Reply with quote

trouble searching?

http://ibmmainframes.com/viewtopic.php?t=40254
Back to top
View user's profile Send private message
apandey

New User


Joined: 31 Aug 2009
Posts: 73
Location: Mumbai

PostPosted: Tue May 24, 2011 6:05 pm    Post subject: Reply to: SQLCODE 00000031}
Reply with quote

Thanks everyone for quick response. icon_biggrin.gif
Back to top
View user's profile Send private message
apandey

New User


Joined: 31 Aug 2009
Posts: 73
Location: Mumbai

PostPosted: Mon May 30, 2011 3:06 pm    Post subject: Reply to: SQLCODE 00000031}
Reply with quote

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 ?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon May 30, 2011 3:24 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
apandey

New User


Joined: 31 Aug 2009
Posts: 73
Location: Mumbai

PostPosted: Mon May 30, 2011 3:55 pm    Post subject: Reply to: SQLCODE 00000031}
Reply with quote

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.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Mon May 30, 2011 4:05 pm    Post subject:
Reply with quote

Handling SQL error return codes in COBOL

Displaying SQLCA fields by calling DSNTIAR
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us