Focal Point
list all mvs datasets starting with particular name

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

December 24, 2010, 12:51 AM
Chan1980
list all mvs datasets starting with particular name
Hi all,

I am using webfocus 7.0 and websphere server in my project.I am configuring a dsn name based on user input(date and report name) and showing in webpage using javascript.For single dataset its working fine,but in some specific reports i wants to show a multiple reports in browser,so for that i wants to list all that dataset starting with that particular dataset name.I believe the below tso command will list the tso name starting with "particular' name.

listc ('txcep.ax') all

but how can i do this in webfocus code,i wants to show this dataset names into one dropdwonlist.(if have multiple reports),the user will select the specific report,

please help me,


Webfocus 7.1,Z/OS,Webpage
December 24, 2010, 05:32 AM
<JG>
Allocate a file using the DYNAM command

Then

Use the LISTC OUTFIE option to direct the output of the listc command to the file

e.g.
DYNAM ALLOC FILE ddname DA your.ddname.whatever SHR
-RUN
TSO LISTC ('txcep.ax') all OUTFILE (ddname)

You should be able to create some form of master to be able to read this file in WF
December 24, 2010, 01:17 PM
Chan1980
Hi JG,

Thanks for yours response.listc returning too many details,i wants only that dataset name in file,how we can get that ?

please advise


Webfocus 7.1,Z/OS,Webpage
December 26, 2010, 04:03 AM
<JG>
try without the ALL option
December 28, 2010, 08:35 AM
Chan1980
Hi JG,

I cannot get any success,the below tso command is returning the dataset names in command window,but i cannot this into file and dropdownlist,

i tried the below code but it's not gave any results,

DEFINE ALLOC FILEREPTFILE DATASET TXCEP.SAMPLE.ALL SHR REUSE
-RUN
-TSO LISTC LVL('TXCEP.NDM.OCS') OUTFILE (REPTFILE)
TABLE FILE REPTFILE
PRINT *
END

please advise it's possible to browse mvs datasets in webfocus report server,

thx


Webfocus 7.1,Z/OS,Webpage
December 28, 2010, 09:16 AM
<JG>
You do not browse files in WebFOCUS
You read them using a master file.

Create a master file called REPTFILE

something like

FILE=REPTFILE ,SUFFIX=FIX
SEGNAME=REPTFILE
FIELDNAME=DATALINE ,E01 ,A80 ,A80 ,$

As you have already issued a DYNAM ALLOC for the file

you treat it like any other data flat file source for WebFOCUS

TABLE FILE REPTFILE
PRINT DATALINE
END

The A80 should match the LRECL of your file TXCEP.SAMPLE.ALL
January 04, 2011, 09:57 PM
Chan1980
Hi,i am sorry,still cannot make this code work,if anyone provide a complete code of writing into file and binding into dropdownlist is really very helpful to me(with some sample dataset name).

thx


Webfocus 7.1,Z/OS,Webpage