using cursor how can you fetch more than one record into a
variable
- 3 Answers
- 6589 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / divya.kadiri
by using loops we can fetch more than one record.try with
for loop
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what sort card you will use to copy the data from one dataset to another dataset?
What is the purpose of dd?
what is the difference between JES3 and JES2?
what happens when COND is coded in JOB statement and when COND is coded inside EXEC statement?
how would you create a temporary dataset? And where will you use them?
List the different jcl statements that are not permitted in the procedures?
How to submit jcl through a cobol program?
Explain how can the submitting users racf authority be overridden in a job stream?
how can a gdg base be created in a jcl. What is the difference between empty and scratch parameter while defining/altering gdg base?
What is one line to pass PARM from JCL to COBOL?
Is automatic restart possible in jcl?
what is DSN parameter and DISP parameter is used for?
Name what parameter directs the output of the job log dataset?
what JCL Procedures?
I want to JCL sort for Non-COMP and COMP-3 fields SORT FIELDS=(1,5,A,6,11,A,12,11,A,19,1,A,20,1,A),FORMAT=BI,EQUALS Length of comp bytes is 11 bytes which start at 6byte and 12 byte considering 11 bytes in comp-3 is 6 bytes. Can anyone tell if the above sort work SORT FIELDS=(1,5,A,6,6,A,12,6,A,19,1,A,20,1,A),FORMAT=BI,EQUALS does not works OK
