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: 1788
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: 19244
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Error while running web tool kit REXX... CLIST & REXX 5
Search our Forums:

Back to Top