using cursor how can you fetch more than one record into a
variable
- 3 Answers
- 6570 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 |
if we give TIME=0 how many sec that job/step
What is multithreading in jcl?
What is the difference between primary and secondary allocations for a dataset?
How to send notification to multiple users through jcl???
What is concatenating?
how can we override data definitions in jcl. can any one give detailed example
Is their any limit for data sets?
i created one base gdg with lrecl = 100 , now i need to create versions with different lrecl =150,200 can it be possible to create like tht ?
In order to continue a job after a return code of 12 in step1, what the step2 exec statement include?
how to code instream data in procedure?
Give the syntax of job specifying jcl statement.
There are two steps in a JCl, the first one generates a report while the second step send an email saying the report has been generated, but the second steps should only be executed when the report file is non-empty. How can it be acheived. We may include steps in between.
COBOL 
