IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Use of SQLERRMC Field in SQL Error


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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
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
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: 1787
Location: Bloomington, IL

PostPosted: Sun Jan 02, 2011 8:27 pm
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

Moderator Emeritus


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

PostPosted: Mon Jan 03, 2011 10:05 am
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 All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts U0016 error in JCL JCL & VSAM 4
No new posts To Unstring spaces in a field COBOL Programming 3
No new posts python on z/OS error no encoding decl... Testing & Performance 0
No new posts IEW2315E 1369 Link error All Other Mainframe Topics 3
No new posts Help required to reset decimal points... DFSORT/ICETOOL 10
Search our Forums:


Back to Top