| View previous topic :: View next topic |
| Author |
Message |
nadh
Intermediate
Joined: 08 Oct 2004
Posts: 192
Topics: 89
|
 Posted: Tue May 17, 2005 7:11 am Post subject: extract 50 records |
 |
|
Hi,
I have a file containing 3 lakhs records. I want to extract from that
1. first 50 records to new file
2. 101 record to 500 record to another new file.
How to do that?
as the input file is having 3 lakh records i'm not able to open it in edit mode.
pls. give me the solution.
Thanks in advance
nadh |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12394
Topics: 75
Location: San Jose
|
|
| Back to top |
|
|
valeti_sashi
Beginner
Joined: 11 May 2005
Posts: 12
Topics: 7
Location: Chennai, India
|
| Posted: Wed May 18, 2005 11:05 am Post subject: |
|
|
HI,
You CAN USE IDCAMS ALSO FOR THIS PURPOSE
OBSERVE THE FOLLOWING PIECE OF CODE, I HAD TESTED IT:
| Code: |
"
000006 //STEP1 EXEC PGM=IDCAMS
000007 //SYSPRINT DD SYSOUT=*
000008 //SYSOUT DD SYSOUT=*
000009 //INDD DD DSN=INPUT DATSET,
000013 //OUTDD1 DD DSN=FIRST OUTPUT DATASET,
000014 // -------
000018 //OUTDD2 DD DSN=SECOND OUTPUT DATASET,
000019 // DISP=(NEW,CATLG,DELETE),
000022 // -------
000024 //SYSIN DD *
000025 REPRO INFILE(INDD) OUTFILE(OUTDD1) COUNT(100)
000026 REPRO INFILE(INDD) OUTFILE(OUTDD2) SKIP(100) COUNT(400)
000027 /*
|
REGARDS,
VALETI SASHIDHAR CHOWDARY |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12394
Topics: 75
Location: San Jose
|
| Posted: Wed May 18, 2005 11:08 am Post subject: |
|
|
Valeti_sashi,
Please post in lower case. Posting in all caps is shouting. btw even though IDCAMS also serves the purpose remember that you need 2 passes(2 repro statements) of the data.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
