using cursor how can you fetch more than one record into a
variable
- 3 Answers
- 6561 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 can the submitting users racf authority be overridden in a job stream?
What is the use of DUMMY statement in the JCL? What is the use of DUMMY Utility in the JCL?
how JCL works?
What does the statements: typrun=scan and typrun=hold do in a JCL statement
How are GDGs concatenated?
COND -> step1 . . step2, Step2, Executes if the CC of step1 is 0. But even if it is NOT 0 and if we dont give COND, will step2 be executed ?
List the different components of jcl statement?
what is static and dynamic call with examples?
1.How to check for the errors using TYPRUN=SCAN?What will be the output if we give TYPRUN=SCAN?
What is TimeStamp, What is TimeStamp error and What is the Abend Code for TimeStamp Error ?
Explain about LMPUT-
How to exclude the duplicate records from two concateded flat files (records from both files must be removed)?
COBOL 
