using cursor how can you fetch more than one record into a
variable
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 |
How do you handle empty files in a JCL ?
how to identify the file used in the JCL is an VSAM file. Just seeing the JCL code how can we track the file as VSAM file?
When space is allocated for an output dataset, what units can be used?
What are the utility programs in jcl?
Define concatenating?
Explain the purpose of the dd keylen parameter?
What is NOTCAT ?
What are the common jcl syntax errors you get? This is not abends?
How to read and write a single record into a file. I would like to use it to enter a single 8-character piece of information and use it to put it into a variable for processing in JCL. Thank you
i have 10,000 records in one input file.i want to sort 1 to 5000 records in one outputfile and remaining records sort in another output file write the syntax for this?
I have a PDS and want to omit few rows of all members of a PDS. How to do it?
hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u