using cursor how can you fetch more than one record into a
variable
- 3 Answers
- 6816 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 |
Is there a way to check for an empty file in JCL other than using IEBCOMPR and the command PRINT COUNT(1)?
Write a JCL by using the below requirement: File1 =1, File2 =11 and output needs to come as File3 =111?
What does a disposition of (NEW,CATLG,DELETE) mean?
How to send different PARM values based on the any condition to the program in a JCL? For example :- If the time is before 12:00 pm, I want to send "A" to some program and if it past 12:00 pm , I want to send "B" as a PARM value to that program. How to do it thur JCL only?
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?
Max. No of DD statements in a job ?
Can we give two user name in NOTIFY parameter in JOBCARD
i have a file which contains duplicates ? my requirement is to eliminate duplicates and these elminated duplicates should be moved to another file can any code this using sort ?
When we give TYPERUN = SCAN , what are the syntax errors we get?
Can there be 2 job statements in a JCL? If yes what is the purpose of doing tha?
How to check empty file in jcl?
A job has 150 steps i want to execute only 57th step
COBOL 
