Interested to Buy Any Domain ? << Click Here >> for more details...
using cursor how can you fetch more than one record into a
variable
- 3 Answers
- 8079 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / divya.kadiri
by using loops we can fetch more than one record.try with
for loop
| Is This Answer Correct ? | 2 Yes | 0 No |
Only single record is retrieved in the host variables with
each fetch.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / swathiii
By using the host variable u can fetch more than one
records.
| Is This Answer Correct ? | 0 Yes | 3 No |
One dataset is creating in the step1 with LRECL of 133 and the same dataset is used in the next step in DISP=SHR mode, but while scanning the JCL the following error is thrwon. Please verify the below JCL $/SEPP030.PROVIDER DD DSN=Z1225BT.F5750PG9.F5910PRV.QC#A6868 //ERRORRPT DD DSN=F5910&ST&IN..F5910EPP.ERRORRPT.P&CYCDATE, --ERRORRPT DD DSN=F5910PG.F5910EPP.ERRORRPT.P, // DISP=&DISNCD,UNIT=&DELQ, -- DISP= (NEW,CATLG,DELETE),UNIT=DELQ, // SPACE=(TRK, (30,15),RLSE), // DCB=&DCB2 -- DCB= (PPG.METMODEL,BLKSIZE=0,LRECL=133,RECFM=FB) $/SEPP030.ERRORRPT DD DSN=Z1225BT.F5910EPP.ERRORRPT.AOUTPUT //SEPP040 EXEC PGM=FILEAID,COND= (0002,EQ,SEPP030) //SYSPRINT DD SYSOUT=* //SYSLIST DD SYSOUT=* //DD01 DD DSN=SYSCMN.PROD.CCLIB (F5910EP1),DISP=SHR $/SEPP040.DD01 DD DSN=Z1225BT.TEST.CCLIB (F5910EP1) E1 - DSS20791E - DATA SET 'Z1225BT.F5910EPP.ERRORRPT.AOUTPUT' HAS AN LRECL OF 133 COULD NOT BE OPENED BECAUSE THE CODED LRECL WAS 80. // DD DSN=F5910&ST&IN..F5910EPP.ERRORRPT.P&CYCDATE, -- DD DSN=F5910PG.F5910EPP.ERRORRPT.P, // DISP=SHR $/ DD DSN=Z1225BT.F5910EPP.ERRORRPT.AOUTPUT please find the error code in the above mentioned lines and please suggest me about the error and the solution for that.
A job has 90 steps i want to execute only step7 and step15
How to execute step2,step1, step3 if step1,2,3 are in order
Can a PROC CALL another PROC ? (in both Instream and Cataloged cases) ?
What are hierarchy levels in jcl?
Name the statement which can be used to send data to another mvs jes3 node?
Hi, I have 3 files say file A , file B and file C.I want to form an output file in which i will have all the records from file A. Files B and C also may contain records that are present in file A.I want those records also to be included in my output file. for eg: file A contains: 1 2 3 file B contains: 2 4 5 file C contains: 1 3 5 So in my output file should look like: 1 2 3 2 1 3 Can any one help ???.....thanks in advance.
Name some of the JCL statements that are not allowed in procs.?
Can there be 2 job statements in a JCL? If yes what is the purpose of doing tha?
What is the use of ikjeft1b utility in jcl?
What is the purpose of disp parameter?
How to find the number of duplicates in a file using Sort?
COBOL 
