using cursor how can you fetch more than one record into a
variable
- 3 Answers
- 7144 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / vaneesh khurana
Only single record is retrieved in the host variables with
each fetch.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the 4 fields in dd statement?
Is it possible to code instream data in a PROC?
what is DSN in JCL and what are the parameters to declare the DSN?
Give the syntax of job specifying jcl statement.
How is a type of file defined in the jcl that executes the cobol program?
What does it mean by Restart and Checkpoint in JCL ? How are checkpoints being taken and what is their usage ? How to use Checkpoint macro on a JOBSTEP ?
What is the function of the dd avgrec keyword in sms datasets?
I have a cobol db2 program(PGM A) where other program (PGM B) will call this program and passes some 50 fields data to PGM A. PGM A has some layout in which it receives the data from PGM B. And this layout has been copied in the linkage section pf PGM A. After getting the data, PGM A writes the data in a flat file in the same layout which it receives from PGM B. PGM B is a simple COBOL pgm. Please provide a JCL to run these programs.
Is it possible to define dd statements as you want?
How does jcl act on a cobol code?
Explain the function of //jcllib statement?
Explain how can a stopped job be started again?
What are the utility programs in jcl?
What parameters can be used to limit the number of records written to a sysout dataset?
What is the difference between run mode and addressing mode?
