using cursor how can you fetch more than one record into a
variable
- 3 Answers
- 6533 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 |
if we give TIME=0 how many sec that job/step
what EXEC statement is and what is the syntax of EXEC statement used in JCL?
what is a cataloged procedure ?
Hi, I have 3 files say file A , file B and file C.I want to form an output file in which i will have all the records from file A. Files B and C also may contain records that are present in file A.I want those records also to be included in my output file. for eg: file A contains: 1 2 3 file B contains: 2 4 5 file C contains: 1 3 5 So in my output file should look like: 1 2 3 2 1 3 Can any one help ???.....thanks in advance.
is step name is compulsory in jcl ?
i want to see the jobs in skeleton queue in diff region. (eg. 7 regions are running means , i want to see all the jobs in 7 regions which are in skel queue using 1 command)
How are datasets concatenated?
Hello Guys, I have 1+ Year Experience in MAINFRAME TESTING. After 1 Week I have an Interview With a Company on Mainframe Testing. Please Could You Guys Please Suggest me What Sections Should I prepare ?? ___Tell Me the Topic Or Appropriate Site & Links. ?? ---------------Thank You
How to execute step2,step1,step3 when step1,2&3 are in order
What is timing concept in mainframe?
what is A-MODE and R-MODE?
what is static and dynamic call with examples?
COBOL 
