Search found 13 matches

by ibmlearner
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: 9812

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.
by ibmlearner
Thu Mar 08, 2007 8:18 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: ROWID
Replies: 2
Views: 5762

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.
by ibmlearner
Thu Mar 08, 2007 8:15 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: CURSOR
Replies: 3
Views: 9240

CURSOR

HI ALL ,,

USING CURSOR HOW TO FETCH SPECIFIC RECORDS ??

SAY THERE ARE 500 RECORDS.

NEED ONLY 201 TO 300 RECORDS

TIA.
by ibmlearner
Thu Mar 08, 2007 8:07 pm
Forum: COBOL
Topic: STRING LENGTH
Replies: 1
Views: 4001

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 ????
by ibmlearner
Thu Mar 08, 2007 7:54 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: FOREIGN KEY
Replies: 1
Views: 4808

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.
by ibmlearner
Thu Mar 08, 2007 7:51 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQLCA
Replies: 3
Views: 7620

SQLCA

HI ALL !!!!!!!


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

WHETHER THE ROW INSERTED OR DELETED SUCCESSFULLY ????

TIA.
by ibmlearner
Thu Mar 08, 2007 7:48 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SINGLE ROW
Replies: 3
Views: 7076

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.
by ibmlearner
Thu Feb 22, 2007 5:20 pm
Forum: JCL
Topic: RESTART - Executing 2 and 3 rd step in 5 step jcl
Replies: 7
Views: 18213

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 ??????
by ibmlearner
Wed Dec 13, 2006 7:08 pm
Forum: JCL
Topic: JCL
Replies: 1
Views: 4141

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...
by ibmlearner
Mon Dec 11, 2006 12:44 pm
Forum: JCL
Topic: ispf
Replies: 1
Views: 4658

ispf

how can i save the changes while in viewmode of jcl?
by ibmlearner
Thu Dec 07, 2006 5:45 pm
Forum: JCL
Topic: IDCAMS
Replies: 2
Views: 10485

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) //
by ibmlearner
Thu Dec 07, 2006 5:34 pm
Forum: JCL
Topic: ISPF query
Replies: 1
Views: 3998

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...
by ibmlearner
Sat Dec 02, 2006 6:19 pm
Forum: JCL
Topic: PROCEDURE's
Replies: 2
Views: 4676

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 ?????