sql code

johnsingh · New User Joined: 11 May 2005 Posts: 22

hi,

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

Thanks in advance

ravikumarreddy · New User Joined: 29 Jul 2005 Posts: 23

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

michaelraj · New User Joined: 01 Sep 2005 Posts: 43 Location: Bangalore

Hi ravikumar,

Thanks for your useful information.

regards,
Mike.

prasanth_thavva · New User Joined: 28 Jul 2005 Posts: 86 Location: Chennai

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