|
INTERVIEW QUESTIONS
MAINFRAME
DB2
DETAILS
Question: I have 1000 records in vsam,I want to read records 500 to 900
Answer: //JOB STATEMENT
//STEP1 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//DD1 DD DSN=DSRC239.KSDS.CLUSTER,DISP=SHR
//DD2 DD DSN=DSRC239.NEW.PS,DISP=SHR
//SYSIN DD *
REPRO INFILE(DD1)-
OUTFILE(DD2)-
SKIP(499)-
COUNT(401)
/*
//
|
|
|
Category |
DB2 Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8984 users |
Added on |
7/22/2011 |
Views |
72921 |
Rate it! |
|
|
Question:
I have 1000 records in vsam,I want to read records 500 to 900
Answer:
//JOB STATEMENT
//STEP1 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//DD1 DD DSN=DSRC239.KSDS.CLUSTER,DISP=SHR
//DD2 DD DSN=DSRC239.NEW.PS,DISP=SHR
//SYSIN DD *
REPRO INFILE(DD1)-
OUTFILE(DD2)-
SKIP(499)-
COUNT(401)
/*
//
Source: CoolInterview.com
//JOB STATEMENT
//STEP1 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//AA1 DD DSN=DSRC239.KSDS.CLUSTER,DISP=SHR
//AA2 DD DSN=DSRC239.NEW.PS,DISP=SHR
//SYSIN DD *
REPRO INFILE(AA1)-
OUTFILE(AA2)-
SKIP(499)-
COUNT(501)
/* Source: CoolInterview.com
Answered by: Shivakumar Deshpande | Date:
| Contact Shivakumar Deshpande
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is the indexset and sequence set in vsam ksds?
|
View Answer
|
|
How to increase table space in db2?
|
View Answer
|
|
What is severity one error in production support?
|
View Answer
|
|
How to Repair the table?
|
View Answer
|
|
What is diff b/w check pending and copy pending?
|
View Answer
|
|
In my jcl ,the 1st step is delete step, if the data set is existing, I want to delete, that one ,if dataset is no existing, I do not want abend the job, how can I code in disp?
|
View Answer
|
|
How to pass return codes from Cobol to jcl?
|
View Answer
|
|
There are two programs say A&B,A is only cobol program,B iscobol-db2 program, how to compile both programs?
|
View Answer
|
|
How to enter in xpediter?
|
View Answer
|
|
Commenly facing errors?
|
View Answer
|
|
What will happened ,if the subprogram is called second time?
|
View Answer
|
|
What will happened .if the file is open in extend mode and corresponding is equal to old in jcl?
|
View Answer
|
|
File opening modes in cobol and corresponding dispositions?
|
View Answer
|
|
Initial position of cursor of the exucuton of open statements?
|
View Answer
|
|
When do you use subroutines?
|
View Answer
|
|
At what stage db2 must be up?
|
View Answer
|
|
Can you display the index?
|
View Answer
|
|
What is the index ,types of index ?
|
View Answer
|
|
What is an intent lock?
|
View Answer
|
|
What is low values and high values?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All DB2 Interview Questions & Answers - Exam Mode /
Learning Mode
|