You can do the following:

1. Run ICETOOL COUNT function to get total number of records

COUNT FROM(input file ddname)

2. Then run SORT utility with SKIP and STOPAFT to get first/last records

hello

i cant get your answer clearly can u explain with example ?

regards

rahul

hi

What you can do is -> first get the total number of records in the file (you may use File-aid -> Utilities - > Copy by this your file would be copied to another file giving total number of records copied). say the number of records is 100. so you need to copy only the 1st & the last record( record no 1 & 100).use following code to get the 1st & last record copied.

//STEP1 EXEC PGM IDCAMS
//DDIN01 DD DSN INPUT FILE NAME
//DDOUT01 DD DSN OUTPUT FILE NAME
//SYSPRINT DD SYSOUT *
//SYSIN DD *
REPRO -
INFILE(DDIN01) -
OUTFILE(DDOUT01) -
SKIP(1) - << THIS OPTION WILL SKIP YOUR FIRST
<< RECORD IN OUTPUT FILE AND
<< START COPYING FROM 2nd RECORD upto 99th record
COUNT(98)
/*
//

Output file will only have 1st & last record.

please let me know if you have some other tweak.

thanks

Prashant

Use IceTool To get Number of Counts.

Consider

//STep1 Exec PGM ICETOOL

//ToolMsg DD Sysout *

//inputfl dd disp fq.sq.input.file

//TOOLIN DD *

COUNT FROM(IN1)

/*

You can use batch fileaid. I do not remember the exact syntax.

//step1 exec pgm fileaid

$$DD01 copy out 1

//step2 exec pgm fileaid

$$DD02 copyback out 1

You can a) mod the same dataset or b) create concatenated dataset.

But that is basically it. For more info look at file-aid batch manual.

Regards

Michael

Count no of records.

Copy the OLD file into another NEW file using FILEAID.

At the end it will prompt no of records added. lets say 50 records added.

Then open the file in edit mode using FILEAID.

And in front of 2 records type DD48 this will delete 48 records including 2 record. So you will have only first and 50th record(last record).