I have 1000 records in vsam,I want to read records 500 to 900?

  • Interview Candidate
  • 6
  • 4562

Showing Answers 1 - 6 of 6 Answers

John

  • Jan 24th, 2006
 

Maintain a counter, give readnext for 499 times in loop. Then process 500 to 900 and close file at 901 record.

S.Sridhar Swarnavel

  • Jun 30th, 2006
 

 

//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)

/*

//

Regards,

Sridhar

  

radhika

  • Oct 17th, 2006
 

select * from emp where rownum<900

minus

select * from emp where rownum<500

  Was this answer useful?  Yes

sunil

  • Jun 6th, 2007
 

select * from tablename
where anyfield in 500,900;

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions