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
- 8119 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 |
What is the use of disp parameter?
if we want to use a gdg which is already created by some job, then how to use the reference of the last generation in a jcl?
if the submitter of a job wants to inform another user about the job completion, how can it be done?
A STEP has more than 1 file as INPUT. And we have to put all these records int 1 output file. How to do ? //InputF DD DSN=ID.File1 DSN=ID.File2 DSN=ID.File3
How to test thru JCL if any file(PS or VSAM) is empty or not. I do not want to use any COBOL prog or Ezytrieve and want to do using utility.
in step1 of a jcl,disp=(mod,delete,delete) step02 exec pgm=ccc,cond=(0,le) will step02 be executed? i)never ii)always iii) iv)... i dont remember options
What is difference between Return Code, user completion code, Abend code and reason Code?
How many instream we can write in single jcl?
what is instream data
How many JOB statements a JCL can have ? If there are more than one JOB statements in a JCL, are they submitted in succession or in parallel ?
What do you understand by the terms: joblib and steplib?
While using SORT FILES =NONE,XSUM I am getting error "ICE172A E XSUM IS NOT SUPPORTED - USE ICETOOL SELECT IF APPROPRIATE"..I want to write duplicate records a a serparte file..how i can do tht?
COBOL 
