Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     list all mvs datasets starting with particular name
Go
New
Search
Notify
Tools
Reply
  
list all mvs datasets starting with particular name
 Login/Join
 
Member
posted
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
 
Posts: 8 | Registered: December 23, 2010Reply With QuoteReport This Post
<JG>
posted
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
 
Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 8 | Registered: December 23, 2010Reply With QuoteReport This Post
<JG>
posted
try without the ALL option
 
Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 8 | Registered: December 23, 2010Reply With QuoteReport This Post
<JG>
posted
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
 
Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 8 | Registered: December 23, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     list all mvs datasets starting with particular name

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.