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 |
How do you run a COBOL batch program from a JCL? How do you run a COBOL/DB2 program?
Is their any set of rules for dd? Explain.
What is a GDG
Why include statement is used in a jcl?
My JOB contains three steps. //STEP1 EXEC PGM=ABC //STEP2 EXEC PGM=DEF //STEP3 EXEC PGM=GHI My Question is 1) I want to execute second step only. How will do. 2) Soppose U consider above three steps are in PROC steps and I want execute the PROC second step only? How to execute the second step only. During exection time its creating any ABEND? Please let me know..........
There are 2 steps in a JCL. If the first step abends due to system or user abend and the second step has COND specified as EVEN or ONLY, will this step still be executed inspite of the abend in the previous step?
What is GDG and what is the maximum limit of versions that can be created?
How to pass the temp dataset form one JOB step to another?
For what purpose steplib and joblib are used ?
What do you know about jcl?
Explain about LMCLOSE�close a data set
What are three parameters you can specify on Job statement as well as on exec stmt ?