using cursor how can you fetch more than one record into a
variable
Answer Posted / swathiii
By using the host variable u can fetch more than one
records.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Are there any set of rules for the names of the steps used in a job? What are they?
in a jcl, a large volume dataset is loaded to a table using bmcload in step1 and an image copy of the loaded table is taken using bmccopy in step2. Step2 abends because the image copy dataset cannot hold the volume of the table. How can this be rectified?
How to compare two files in SYNCSORT and on the mismatch record should be deleted from second file.
why should SYSIN DD * statement should not be included inside a PROCedure snippet??? please answer this.. i need to know.
How can a fb file convert to vb file using sort program?
Explain about LMFREE�free data set from its association with data ID
what is use of space parameter in dd statement?
Suppose there are 2 Input files Infile-1 and Infile-2. Both the Files contain Employee Records. You need to compare both the files and Write the Common Records in third file named Outfile. How can we do this using File-Aid?
For what purpose steplib and joblib are used ?
How would you understand error(execution phase)?
Explain how can return codes be tested before execution of a job step?
if the submitter of a job wants to inform another user about the job completion, how can it be done?
Is their any limit for data sets?
Why block size is multiple of lrecl in jcl?
What is the function of the dd dcb keyword?