IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


SQLSTATE vs SQLCODE in Online program



Support for CICS/ESA, CICS/TS & Transaction Gateway, CICS Configuration Manager and CICS Performance Analyzer
Post a reply

SQLSTATE vs SQLCODE in Online program

Postby kumar009 » Wed Apr 23, 2014 9:07 pm

Why SQLSTATE is used after every SQL query in COBOL CICS program rather than SQLCOCE ? IS there any specific reason ? Special benefit over it ?
kumar009
 
Posts: 10
Joined: Wed Apr 23, 2014 11:48 am
Has thanked: 0 time
Been thanked: 0 time
Top

Re: SQLSTATE vs SQLCODE in Online program

Postby NicC » Thu Apr 24, 2014 3:55 am

Cannot say that I have ever seen SQLSTATE used after ANY SQL query whereas the checking of SQLCODE should be mandatory.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times
Top

Re: SQLSTATE vs SQLCODE in Online program

Postby kumar009 » Thu Apr 24, 2014 10:49 am

At my site, In batch programs every SQL query is followed by EVALUATing SQLCODE, But when it comes to online programs every SQL query follows SQLSTATE checking. Is it a site specific not the general practice ?
kumar009
 
Posts: 10
Joined: Wed Apr 23, 2014 11:48 am
Has thanked: 0 time
Been thanked: 0 time
Top
Post a reply

Return to CICS

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks