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
 

 

use of SQLERRMC

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
angi_pri

New User


Joined: 04 Jun 2008
Posts: 6
Location: bangalore

PostPosted: Tue Jun 10, 2008 2:44 pm    Post subject: use of SQLERRMC
Reply with quote

hi friends,

Can anyone suggest the answer for the below question?

Which of the following statements correctly describe the use of SQLERRMC?

A.It is a variable contained in the SQLCA.

B.It is the data structure that contains the SQLCODE variable.

C.It provides additional information associated with an error returned by the execution of the last SQL statement.

D.It is the field used to pass parameters used by the SQL ROLLBACK command.

E.It is part of the group structure variable SQLERRM.
Back to top
View user's profile Send private message

Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Tue Jun 10, 2008 3:12 pm    Post subject:
Reply with quote

A & C hold good in the given options.
Back to top
View user's profile Send private message
krunalbafna
Warnings : 1

Active User


Joined: 18 Jan 2010
Posts: 143
Location: Pune

PostPosted: Sun Jan 02, 2011 6:53 pm    Post subject: What does SQLERRMC =00C90080.00000200.TREN10NW.NEWBADDR
Reply with quote

Hi while executing my cobol db2 code ,
i got following error:
SQLERRMC =00C90080.00000200.TREN10NW.NEWBADDR
SQLCODE = .904
My job abended with User abend U0666.

Kindly provide information what does above SQL error message shows and what approach should for successful run.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


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

PostPosted: Sun Jan 02, 2011 8:27 pm    Post subject: Re: What does SQLERRMC =00C90080.00000200.TREN10NW.NEWBADDR
Reply with quote

krunalbafna wrote:

SQLERRMC =00C90080.00000200.TREN10NW.NEWBADDR
SQLCODE = .904
My job abended with User abend U0666.

Kindly provide information what does above SQL error message shows and what approach should for successful run.

Your program has been possessed by Satan; have it exorcised.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Jan 03, 2011 10:05 am    Post subject:
Reply with quote

Hello,

Quote:
Kindly provide information what does above SQL error message shows
At the top of thye page is a link to "IBM Manuals". Among these are some "DB2 Nessages & Codes".

Read about the -904 and correct the problem. If you find something in the manual that is not clear post what you found and your doubt. Someone will be able to clarify.

There is also info about the 00C90080 in the manual. . .
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:



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