Hello

Is there a way to to read multiple GDG's in Webfocus or Focus.

We have a 30 GDG files of daily history that we want webfocus to be able to read all of them in the same execution of the fex.

Any help would be appreciated.

Thanks

Dan

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

Mainframe JCL:

 
//DDNAME DD DSN=LEV1.LEV2.LEV3(+0), DISP=SHR
//       DD DSN=LEV1.LEV2.LEV3(-1), DISP=SHR
//       DD DSN=LEV1.LEV2.LEV3(-2), DISP=SHR
//       DD DSN=LEV1.LEV2.LEV3(-3), DISP=SHR
//       DD DSN=LEV1.LEV2.LEV3(-4), DISP=SHR
//       DD DSN=LEV1.LEV2.LEV3(-5), DISP=SHR
//       DD DSN=LEV1.LEV2.LEV3(-6), DISP=SHR
.
.
//       DD DSN=LEV1.LEV2.LEV3(-29), DISP=SHR

Mainframe CLIST:
DYNAM ALLOC DD

There is a chapter in the manual "MVS/TSO Guide to Operations". It has instructions on DYNAM ALLOC, DYNAM CONCAT and other DYNAM commands... Probably in Dev Studio Help, also.

Windows/UNIX:

FILEDEF DDNAME DISK PATH/DSN (LRECL XXX RECFM F/V

OS is not mentioned in your question, but, this "may" lead you to SEARCH on key words and/or documentation...

hth

This message has been edited. Last edited by: Tom Flynn,

It has been a while, since I've been on the mainframe, but you might want to take a look at doing a DYNAM ALLOC for each of the GDG datasets, and then a DYNAM CONACT to concatenate the datasets into one DD name.

In cases like this, where I had many generations of data, I would try to dynamically construct my DYNAM ALLOC statements, so I wasn't concatenating any more datasets, than the query needed.

For example, if the current request only needed the last weeks worth of data, the code would only allocate and concatenate the last seven of the daily GDG's.

This message has been edited. Last edited by: David Briars,

If you do not designate a generation number on your dataset, it will read all generations.

For z/OS, reads the most current generation:
DYNAM ALLOC FI TEST DS YOUR.DATASET.NAME.HERE(0) SHR REU

Read all generations:
DYNAM ALLOC FI TEST DS YOUR.DATASET.NAME.HERE SHR REU