View previous topic :: View next topic
|
Author |
Message |
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi All,
I have two files like below
First file:
VB
Sample records
Code: |
AAABBBT6QJDBG.CXTDNAS.CXT03AX1.INDOC(D2TKX2FX)
AABBBBT6QJDBG.CXTDNAS.CXT03AX1.INDOC(D2TKXAFX) |
Second file
PO
VB
File name :T6QJDBG.CXTDNAS.CXT03AX1.INDOC
Contain member like
D2TKX2FX
D2TKXAFX
D2TKX2FX contain data as
Required result
Basically we want to merge the records.
and get them in a single line rather then having reference to dataset name.
Please advise |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
Looks like the job for a Rexx exec.
I do not think it will work by using Sort. |
|
Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
guptae wrote: |
Required result
|
You need the output to have first 6 bytes from file 1 and the RESIZED data from each PDS member?
will the PDS members going to be decided at runtime? |
|
Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
|
|
|
|
daveporcelan wrote: |
Looks like the job for a Rexx exec.
I do not think it will work by using Sort. |
Technically you can read the VB file consisting of input file names and build A JCL concatenating all the file names with RESIZE option and submit the job via INTRDR and get the desired results. |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
I guess I always default to Rexx because I am much stronger with it.
I work with sort often, but do not have the creativity needed to accomplish such a task.
It does appear to be simpler to do with Rexx (in my warped mind). |
|
Back to top |
|
|
|