SQLCA

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
User avatar
ibmlearner
Member
Posts: 13
Joined: Sat Dec 02, 2006 5:57 pm

SQLCA

Post by ibmlearner » Thu Mar 08, 2007 7:51 pm

HI ALL !!!!!!!


HOW TO SEE THE UPDATED MESSAGES IN SQLERRD (SQLCA).

WHETHER THE ROW INSERTED OR DELETED SUCCESSFULLY ????

TIA.
Thanks & Regards
-------------------------
Learner

Veera
Moderator
Posts: 111
Joined: Wed Feb 22, 2006 2:59 pm

Post by Veera » Fri Mar 09, 2007 11:52 pm

under SQL = 0 , I mean when the Query is executed succesfully you
can display or move into other working storage varaible the values of the varaible of SQLCA like SQLERRD(3) and othes too.
I dont have DB2 to run a quick test ..let us know if it doesn work.

Thanks
Veera

User avatar
Sheela
Member
Posts: 14
Joined: Mon Feb 26, 2007 8:17 am
Location: Chennai

DB2 - SQLCA SQLERRD

Post by Sheela » Sat Mar 10, 2007 7:03 am

Hi ibmlearner,

i dont know about messages, but SQLERRD(3) contains number of
records updated/deleted by the sql. If it contains 2, which means , 2 records updated/deleted by the sql.
Regards,
Sheela

academyindia4

Topic deleted by Admin

Post by academyindia4 » Fri Jan 15, 2016 10:06 pm

<< Content deleted By Admin >>

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others