Focal Point
[SOLVED] Dynam Alloc Multiple Mainframe Files Using Same MFD

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8917028416

December 28, 2011, 09:42 AM
ktnj
[SOLVED] Dynam Alloc Multiple Mainframe Files Using Same MFD
Hello all,

I want to allocate two versions of the same file using the same MFD.
For Example:
DYNAM ALLOC DD PLFILE DS FILE.M2011JAN SHR REU
DYNAM ALLOC DD PLFILE DS FILE.M2011FEB SHR REU

Is there a way to allocate the second file (feb) without having to create a new MFD name?

Thanks!
Z/OS Mainframe Webfocus 7.17

This message has been edited. Last edited by: Kerry,


December 28, 2011, 10:31 AM
Tom Flynn
  
DYNAM ALLOC DD FILE1 DS FILE.M2011JAN SHR REU
DYNAM ALLOC DD FILE2 DS FILE.M2011FEB SHR REU
DYNAM CONCAT PLFILE FILE1 FILE2



Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
December 28, 2011, 11:10 AM
ktnj
I don't wamt to concatinate the files.

I want to join them so I have the Jan and Feb fields on the same record and I can subtract the difference. Thanks


December 28, 2011, 12:03 PM
Tom Flynn
It's concatenate.

And JOINing them with the same Masterfile name would "not" do that???

Table them out, 1 at a time, and HOLD them, using ASNAMES to uniquely identify the columns needed for math, then JOIN the HOLD files.


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
December 28, 2011, 04:01 PM
Waz
Seems to me that it would be easier to have a second master.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

December 29, 2011, 10:08 AM
ktnj
[Solved] Thanks