hi kumar ,
if u decalred a CURSOR in WORKING-STORAGE SECTION , the CURSOR can be used anywhere ( any paragraphs) in your souce program.
if u declared in PROCEDURE DIVISION , the CURSOR can be used only that particular paragraph.
correct me if im wrong.
Search found 13 matches
- Tue Apr 03, 2007 7:44 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: What is the diff between declaring a cursor in WSS or PD?
- Replies: 4
- Views: 15021
- Thu Mar 08, 2007 8:18 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: ROWID
- Replies: 2
- Views: 9096
ROWID
HI ALL..
WHAT IS ACTUALLY ROWID.
ITS FOR INDENTFYING THE ROW,MEANS THEN
WHAT IS THE USE OF INDEXES ???????
IS (UNIQUE) INDEX USES ROWID???
TIA.
WHAT IS ACTUALLY ROWID.
ITS FOR INDENTFYING THE ROW,MEANS THEN
WHAT IS THE USE OF INDEXES ???????
IS (UNIQUE) INDEX USES ROWID???
TIA.
- Thu Mar 08, 2007 8:15 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: CURSOR
- Replies: 3
- Views: 13505
CURSOR
HI ALL ,,
USING CURSOR HOW TO FETCH SPECIFIC RECORDS ??
SAY THERE ARE 500 RECORDS.
NEED ONLY 201 TO 300 RECORDS
TIA.
USING CURSOR HOW TO FETCH SPECIFIC RECORDS ??
SAY THERE ARE 500 RECORDS.
NEED ONLY 201 TO 300 RECORDS
TIA.
- Thu Mar 08, 2007 8:07 pm
- Forum: COBOL
- Topic: STRING LENGTH
- Replies: 1
- Views: 5397
STRING LENGTH
HI ALL ,,
HOW TO FIND THE LENGTH OF THE STRING ???
SAY
01 A PIC X(10)
I HAVE USED ONLY 7 BYTES.
HOW TO CALCULATE THIS ????
IS THERE ANY LOGIC ????
HOW TO FIND THE LENGTH OF THE STRING ???
SAY
01 A PIC X(10)
I HAVE USED ONLY 7 BYTES.
HOW TO CALCULATE THIS ????
IS THERE ANY LOGIC ????
- Thu Mar 08, 2007 7:54 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: FOREIGN KEY
- Replies: 1
- Views: 7279
FOREIGN KEY
HI ALL ,,,,
1 ) HOW MANY PRIMARY KEYS AND FOREIGN KEYS ARE POSSIBLE
FOR ONE TBALE ???
2) THE MAX NO COLUMS IN ONE TABLE IS 224 IS IT CORRECT ???
TIA.
1 ) HOW MANY PRIMARY KEYS AND FOREIGN KEYS ARE POSSIBLE
FOR ONE TBALE ???
2) THE MAX NO COLUMS IN ONE TABLE IS 224 IS IT CORRECT ???
TIA.
- Thu Mar 08, 2007 7:51 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: SQLCA
- Replies: 3
- Views: 13288
SQLCA
HI ALL !!!!!!!
HOW TO SEE THE UPDATED MESSAGES IN SQLERRD (SQLCA).
WHETHER THE ROW INSERTED OR DELETED SUCCESSFULLY ????
TIA.
HOW TO SEE THE UPDATED MESSAGES IN SQLERRD (SQLCA).
WHETHER THE ROW INSERTED OR DELETED SUCCESSFULLY ????
TIA.
- Thu Mar 08, 2007 7:48 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: SINGLE ROW
- Replies: 3
- Views: 11439
SINGLE ROW
HI ALL !!!!!!!
HOW DO I KNOW THAT IM SELECTING A SINGLE ROW ????
WE CAN SAY WHEN WHERE CLAUSE IN SELECT STATEMENT.
APART FROM THAT ANY ANSWER PLZ ???
TIA.
HOW DO I KNOW THAT IM SELECTING A SINGLE ROW ????
WE CAN SAY WHEN WHERE CLAUSE IN SELECT STATEMENT.
APART FROM THAT ANY ANSWER PLZ ???
TIA.
- Thu Feb 22, 2007 5:20 pm
- Forum: JCL
- Topic: RESTART - Executing 2 and 3 rd step in 5 step jcl
- Replies: 7
- Views: 26645
RESTART - Executing 2 and 3 rd step in 5 step jcl
HI ALL
SAY I HAV 5 STEPS,
//--------JOB CARD --------RESTART=STEP2
//STEP1------
//STEP2------
//STEP3------
//STEP4------
//STEP5------
IM RESTARTING THE JOB FROM THE 2 ND STEP,
MY REQ IS ONLY STEP2 AND STEP3 TO BE EXECUTED ??????
LET ME KNOW APART FROM NULL (//) ANY OTHER WAYS R THERE ??????
SAY I HAV 5 STEPS,
//--------JOB CARD --------RESTART=STEP2
//STEP1------
//STEP2------
//STEP3------
//STEP4------
//STEP5------
IM RESTARTING THE JOB FROM THE 2 ND STEP,
MY REQ IS ONLY STEP2 AND STEP3 TO BE EXECUTED ??????
LET ME KNOW APART FROM NULL (//) ANY OTHER WAYS R THERE ??????
JCL
HI ALL, 1) plz anyone give me the exact meaning of abend code,condition code, error code ?????? 2) why the PROC"S pds ( in which pds proc resides) should always have the RECORD format is FB ??? 3) why load module should always have the record format is UNDEFINED ???? 4) what is the diff between symb...
ispf
how can i save the changes while in viewmode of jcl?
IDCAMS
HI ALL. can we create a dataset by using IDCAMS utility??? my JCL... //ABC123DE JOB (ACCT#),NOTIFY=&SYSUID //STEP0A EXEC PGM=IDCAMS //DD1 DD DSN=TEST0001.TEST01.PDS , DISP=(NEW,KEEP) // UNIT=SYSDA, // SPACE=(TRK,(1,1),RLSE) // DCB=(RECFM=FB,LRECL=80,BLKSIZE=800) //
- Thu Dec 07, 2006 5:34 pm
- Forum: JCL
- Topic: ISPF query
- Replies: 1
- Views: 6097
ISPF query
HI ALL,,, 1) when i edit r do any actions on any PDS with the help of 3.4 option im getting the error message "RECORD FORMAT WAS NOT FOUND" 2) when i edit r do any actions on any MEMBERS within the PDS with the help of 3.4 option im getting the error message "NO CONNECTION" THESE ABOVE TWO CASES HAP...
- Sat Dec 02, 2006 6:19 pm
- Forum: JCL
- Topic: PROCEDURE's
- Replies: 2
- Views: 7347
PROCEDURE's
hi all,,,,
1 ) in INSTREAM PROC can we call CATLG PROC ????
2) INSTREAM PROC can call another INSTREAM PROC within the same
job ?????
1 ) in INSTREAM PROC can we call CATLG PROC ????
2) INSTREAM PROC can call another INSTREAM PROC within the same
job ?????