Interested to Buy Any Domain ? << Click Here >> for more details...
using cursor how can you fetch more than one record into a
variable
- 3 Answers
- 8132 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 |
How to DEBUG a JCL?
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 the use of ikjeft1b utility in jcl?
What is maximum length of block size?
5 Answers Cap Gemini, Kanbay, TCS,
Suppose i have 2 steps in my pgm. Step1- creates a file, Step2 - generates report from file in step1, What changes have to be made in Step2, so that if the file in Step1 is empty Step2 should not be executed? No changes to be made to Step1.
Is there a way to check for an empty file in JCL other than using IEBCOMPR and the command PRINT COUNT(1)?
How to pass data to a program that is coded in an exec statement?
What is the purpose of dd?
What is the purpose of dd dummy statement?
What is the purpose of disp parameter?
If the proc stepname is excluded while overriding the COND, TIME, REGION and PARM parameters while calling the proc, will the override only apply to the first step in the proc or all the steps for all the above parameters?
what is the function of iebcompr?....is it compare record length or characteristics of a dataset?...pls explain with examples.......
COBOL 
