using cursor how can you fetch more than one record into a
variable
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
Explain how can return codes be tested before execution of a job step?
What are the rules employed while naming the steps in a job?
Differentiate between addressing mode and run mode.
Is automatic restart possible in jcl? If yes, how?
What is Cataloged Procedures?
What is the function of the steplib dd statement?
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?
what JCL Procedures?
Explain the hierarchy levels in jcl?
what is DSN in JCL and what are the parameters to declare the DSN?
How jcl work to handle various input output file operations?
How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?
What do you understand by the term “keyword” with respect to jcl and what is the opposite of the term?
How to resolve the error "WER488A JOIN CAPACITY EXCEEDED" I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem? I am using SYNCSORT with JOINKEYS to compare 2 files. I am Getting error - > WER488A JOIN CAPACITY EXCEEDED There are 2 files to be compared with about 2 million records each. LRECL is 3665. Can somebody give a pointer as to how to resolve this problem?
How can a stopped job be started again?