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
 

 

sql code

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
johnsingh

New User


Joined: 11 May 2005
Posts: 22

PostPosted: Mon Sep 05, 2005 4:22 pm    Post subject: sql code
Reply with quote

hi,

what is the picture clause of sql code
what is parameter in binding jcl


Thanks in advance
Back to top
View user's profile Send private message

ravikumarreddy
Warnings : 1

New User


Joined: 29 Jul 2005
Posts: 23

PostPosted: Mon Sep 05, 2005 5:59 pm    Post subject: Re: sql code
Reply with quote

hi

pic clause for SQL CODE is s9(9) comp-5.

just go thru following structure of SQLCA.

01 SQLCA SYNC.
05 SQLCAID PIC X(8) VALUE "SQLCA ".
05 SQLCABC PIC S9(9) COMP-5 VALUE 136.
05 SQLCODE PIC S9(9) COMP-5.
05 SQLERRM.
05 SQLERRP PIC X(8).
05 SQLERRD OCCURS 6 TIMES PIC S9(9) COMP-5.
05 SQLWARN.
10 SQLWARN0 PIC X.
10 SQLWARN1 PIC X.
10 SQLWARN2 PIC X.
10 SQLWARN3 PIC X.
10 SQLWARN4 PIC X.
10 SQLWARN5 PIC X.
10 SQLWARN6 PIC X.
10 SQLWARN7 PIC X.
10 SQLWARN8 PIC X.
10 SQLWARN9 PIC X.
10 SQLWARNA PIC X.
05 SQLSTATE PIC X(5).
who
Back to top
View user's profile Send private message
michaelraj

New User


Joined: 01 Sep 2005
Posts: 43
Location: Bangalore

PostPosted: Tue Sep 06, 2005 12:54 pm    Post subject:
Reply with quote

Hi ravikumar,

Thanks for your useful information.

regards,
Mike.
Back to top
View user's profile Send private message
prasanth_thavva

New User


Joined: 28 Jul 2005
Posts: 86
Location: Chennai

PostPosted: Tue Sep 06, 2005 2:55 pm    Post subject: parameter in jcl bind
Reply with quote

hi,
1>validate(run/bind)-default is validate at run.. it checks authorization for an object
2>sqlerror(continue/error)-- if an error occurs in sql it wont bother it continues to create a incorrect package almost this parameter error..if error it wont create a package...
3>ACQUIRE(USE)/RELEASE(COMMIT)...
WHEN EVER SQL THREAD IS IMPLEMENTED THAT TIME ONLY THE LOCKS WILL IMPOSED ON TABLE WHICH TABLE REFERED .AFTER COMIT IT WLL BE RELEASED AS PER THE RELEASE PREFERENCE
4>ISOLATION LEVEL(CS/UR/RR)--DEFAULT IS CS(CURSOR STABILITY) WHICH IS IMPLEMENTING ON TABLE / TABLE SPACE LEVEL ,,,IF THE CURRENT PAGE IS MOVING TO ANOTHER PAGE..(INCLUDING THE UPDATION TAKEN PLACE) ..THE LOCKS ON FIRST IS RELEASED...THIS IS CS//
RR--- TABLE/TABLESPACE LOCKING WLL BE TAKEN AND WHEN PLAN STARTS EXECUTION IT WLL BE LOCKED AND AFTER COMIT IT RELEASES LOCK...
UR--DIRTY READ./....N NUMBER TRANSACTION CAN ACCESS THE ROW IRRESPECT OF UPDATION WHICH TENDS TO UNCERTAINITY OF DATA..WHICH IS NOT A POLICY OF DB2..


4>QUALIFIERS-- IMPORTANT--WHEN U R MOVING PGM TO ONE REGION TO ANOTHER REGION AT BIND TIME WE CAN ADD QUALIFIER S TO OBJECT WITH OUT CHANGING THE CODE SIMPLY SPECIFYING THIS


IF ANY WRONG PLZ INFORM ME
BYE ALL D BEST
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts CA Workload Automation event code help vinu78 CA Products 10 Wed Mar 01, 2017 10:05 am
No new posts MAX-RC 88 and Return code 606 in DFH0... lind sh CICS 2 Tue Jan 24, 2017 1:23 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 2 Thu Jan 12, 2017 12:02 pm


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