Sign Up Login


  1. Categories >> Software >> MainFrame >> IBM MainFrame >> JCL
  2. Suggest New Category

using cursor how can you fetch more than one record into a
variable

Question Posted / satheesh

Answers were Sorted based on User's Feedback



using cursor how can you fetch more than one record into a variable..

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

using cursor how can you fetch more than one record into a variable..

Answer / vaneesh khurana

Only single record is retrieved in the host variables with
each fetch.

Is This Answer Correct ?    0 Yes 0 No

using cursor how can you fetch more than one record into a variable..

Answer / swathiii

By using the host variable u can fetch more than one
records.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More JCL Interview Questions

i have a jcl in which 4 & 5 step creates a new generation. 4th step output is as input for the 6th step & 5th step output is used as input in the 7th step. How they are refered as in the 6th & 7th steps? If the job abends in 6th step then how the 5th step output is refered in 7th step?

6 Answers   IBM,

Can you execute a PROC from another PROC?

8 Answers   Keane India Ltd,

hi friends........if u know syntax of IEBEDIT IN JCL

2 Answers  

I have a jcl which is using 2 data sets i want to override those data sets. how can i override the files within the JCL. Give me the syntax. Make sure that it is not calling any Proc.

1 Answers  

Hi, Say I have 10 flat files and I want to copy all these 10 flat files to a GDG versions flat files (I have GDG base: FDWS01.TEST.RESTORE) in one shot. Can we do that in one shot using a JCL. May be by using IEBGENER. It's a bit urgent. So anyone's fast rely would be appreciated.. Thanks in advance.. 10 flat files ----------------------------------- FDWS01.SUB.RESTORE1 FDWS01.SUB.RESTORE2 FDWS01.SUB.RESTORE3 ; ; FDWS01.SUB.RESTORE10 TO GDG versions ----------------------- FDWS01.TEST.RESTORE.G0001V00 FDWS01.TEST.RESTORE.G0002V00 FDWS01.TEST.RESTORE.G0003V00 ; ; FDWS01.TEST.RESTORE.G0010V00

4 Answers  




Is there GOTO and SWITCH-CASE available in JCL ? Is IF-THEN-ELSE available in JCL also just like it is available for VSAM datasets under Model Commands category ?

1 Answers   IBM,

How to override a dsn that is contained in a proc called by another proc? I need to do the override in the calling jcl?

0 Answers  

wht do u mean by internal reader in jcl ? wht is the use of internal reader ?

1 Answers   Syntel,

hi,i have joined in mainframe course recently. ihave a doubt ragarding restart parameter.what is d use of it. and what is d syntax for it. any one give me d answer pls.

3 Answers  

What is the difference between run mode and addressing mode?

0 Answers  

why jobstep can't be more than 255 and for GDG has max limit 255 . Is there any relation between the two

1 Answers   IBM, Perot Systems,

diff bw SB37,SD37,SE37 ?( bcz these 3 belongs Space related abends only)

4 Answers   RBS,

For more JCL Interview Questions Click Here
Categories