i just need the first and last record from a sequencial
file?how
Answers were Sorted based on User's Feedback
Answer / paray2x
The best option is to used File-Aid processing options.
If not,
1. Use SORT FIELDS=COPY, STOPAFT=1 to get the first record.
2. Insert line numbers in the file using SEQNUM fucntion of
SORT. Then, do a SORT FIELDS on this line number in
descending order, save it a temp file.
3. Use SORT FIELDS=COPY, STOPAFT=1 on this temp file to get
the last record.
| Is This Answer Correct ? | 0 Yes | 3 No |
USE SKIP(N) To skip number of records
if 10 accounts are there and u want to skip first 7 records
use
//sysin dd*
repro infile(dd1) -
outfile(dd2) -
skip(07) -
count(03)
/*
for 1st and last
//sysin dd*
repro infile(dd1) -
outfile(dd2) -
count(1) -
skip(08) -
count(01)
/*
| Is This Answer Correct ? | 1 Yes | 4 No |
Can a PS file be read in reverse order?If so,how
What is 'S0C7' abend?
What is primary allocation for a dataset?
how to split a file
What are the default system and catalog libraries in JCL?
What is STEPLIB, JOBLIB? What is it used for?
How do you skip a particular step in a proc/JOB?
What are the differences between JES2 & JES3 ?
How to Enter The Spool Area In Real Time?
Is it possible to left uncode disp?
State the uses of syspring, sysin, sort fields, sum fields and dummy.
I HAVE A SEQUENTIAL FILE CONTAINING ONE RECORD IN WHICH I HAVE ONE FIELD AS CUSTOMER IDENTITY NUMBER FIELD WHICH IS A SIGNED FIELD. HOW TO SEQUENTIALLY INCREMENT THIS FIELD USING OVERLAY PARAMETER?.