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: 15021

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

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: 7059

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: 14270

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: 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...
by ibmlearner
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 ?????