View previous topic :: View next topic
|
Author |
Message |
nileshpbhosle Currently Banned New User
Joined: 09 Jul 2008 Posts: 3 Location: hydrabad
|
|
|
|
hi,
i want to retrive data from flat file depending upon count,suppose we need to extract some random data like every 10th or 100th record from flat file,for this i have use JCL and it should be parameter driven.can send me source code for this or at least tell how will i achieve this using parameter concept in JCL. |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
JCL by itself can't read files. You need some program.
You can either write your own program or use a ready-made program (aka - utility).
O. |
|
Back to top |
|
|
nileshpbhosle Currently Banned New User
Joined: 09 Jul 2008 Posts: 3 Location: hydrabad
|
|
|
|
actually i want code i dont know how will i achieve this.i want that JCL program which will extract 10th record from flat file using parameter concept. |
|
Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
No problems, I can write you the code, and also test it.
My fee (for the summer only) is $90 per hour.
O. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Nilesh,
First thing your requirement is not at all clear.
As O pointed, you need to have some program to read flat file.
You dont know the language/utility required for this. But wanted a result. Seems like a 'very good design' (read in opp way). |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
nileshpbhosle wrote: |
actually i want code i dont know how will i achieve this.i want that JCL program which will extract 10th record from flat file using parameter concept. |
Well, little did I could understand from this, however, do you want every tenth record or only first 10th record.
Does this
Code: |
//SYSIN DD *
OPTION COPY
OUTFIL STARTREC=?,SAMPLE=?
/* |
solves your problem... |
|
Back to top |
|
|
nileshpbhosle Currently Banned New User
Joined: 09 Jul 2008 Posts: 3 Location: hydrabad
|
|
|
|
thanx anuj,
but i want it for every 10th record,every 10th record should be fetch from flat file and i have to insert it into other file.but i have do this using parameter driven JCL. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hmm..(old Villain ..re-entry)..just in four posts he is banned... |
|
Back to top |
|
|
|