using cursor how can you fetch more than one record into a
variable
- 3 Answers
- 7237 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 |
Can I concatenate various datasets whose organization are different from each other. Lets say I want to cancatenate a PDS file, a PS file, a GDG file etc. Can You do that ?? If yes, how ? is there any separate Utility to do so ???
What is the job entry system used in your project? based on what criteria the sequence of jobs are picked if priority is not mentioned in the job card?
How to override loadlib?
I have many files which i am receiving from client everyday. I have one step for every file to check for empty or not. Here client gives 30 files i need to check for every file for empty or not and i need to perform 30 steps. Can I do it in single step. Dynamically i need to change the File name in my step.
What is timing concept in mainframe?
At what stage, operator can change the class and priority of a submitted job?
How to concatenate different LRECL of files?
What is a JCL Command statement ?
Is there a way to check for an empty file in JCL other than using IEBCOMPR and the command PRINT COUNT(1)?
hello friends ,i have exam in Hsbc,pls any on send me placement papers and technical questions on mainframes,thank u
Many jcl statements contain specific values designed to direct and control the execution of the statement. What are these fields called?
Min no of member?s (PDS) in one directory block?
COBOL 
