 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [Answered] Question: Report From .ACX Files?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [Answered] Question: Report From .ACX Files? Read-Only TopicGo | Search | Notify | Tools |
| [Answered] Question: Report From .ACX Files? | Login/Join |
| Master |
Can I report from the contents of all of my .acx files, stored within one particular app folder? That is, if my .acx looks like this: SEGNAME=ALERT, TABLENAME=myschema.ALERT, CONNECTION=MYCONN, KEYS=3, $ Can I create a report that looks like this? File Table Name CONNECTION ----- ---------- ---------- ALERT myschema.ALERT MYCONN I searched and saw some threads regarding reporting from a MASTER file, but couldn't quite ascertain how to pull data from an ACCESS file.This message has been edited. Last edited by: David Briars,
| |||
|
| Virtuoso |
The content of an access file follows the rules for a comma-delimited data file.* The attributes can vary, depending on the SUFFIX in the Master file. To the best of my recollection, it always corresponds to a single-segment COM file. If you set up a Master for a single-segment data file, covering every possible attribute (the NAME part of NAME=VALUE), it should be straightforward to filedef the access file and report its content. Note that, in multiple-segment synonyms (e.g., cluster joins and business views), there can be multiple segments, and the filename may be absent from the text of the access file. So reporting on a whole library's worth of access files in a single TABLE FILE would take a little more doing. --- *That used to be true of Master files as well, until DEFINE was introduced. | |||
|
| Expert |
get a list of them first APP QUERY yourapp HOLD TABLE FILE FOCAPPQ PRINT * IF FILENAME CONTAINS '.acx' -*ON TABLE HOLD AS HHOLD FORMAT ALPHA END
| |||||
|
| Silver Member |
I think your acx file should have the DB connection information and not the table/column names. so i am not sure what you are going to report from the access file. Webfocus 7.1.6, Webfocus 7.7, Webfocus 8 | |||
|
| Expert |
Yes you can create that report. Just use SYSTABLE. This assumes that your masters and access files are in the path. e.g. TABLE FILE SYSTABLE
PRINT NAME
SERVER REALNAME
WHERE NAME EQ '{insert table name here}'
ENDWaz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Master |
Thank you Waz and Susannah! Putting your two code samples together, looks exactly like what I needed: APP QUERY MYPATH HOLD
-RUN
DEFINE FILE FOCAPPQ
MYNAME/A70 = GETTOK(FILENAME, 70, 1, '.', 70, MYNAME);
END
-*
TABLE FILE FOCAPPQ
PRINT MYNAME
IF FILENAME CONTAINS '.acx'
ON TABLE SAVE AS FNAMES
END
-RUN
-*
APP PATH MYPATH
TABLE FILE SYSTABLE
PRINT NAME AS 'ACX File'
REALNAME AS 'Relational Schema.Table Name'
SERVER AS 'Connection'
IF NAME EQ (FNAMES)
END
-EXIT | |||
|
| Expert |
David, This is great - I've made a copy of the code. Unfortunately, this doesn't handle multiple-segment synonyms. KEYCOLUMNS displays the correct number of keys in a multiple-segment synonym, but that's all it does for these types of acx files. Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
glad we could help #transhemispherical_fistbump!  | |||
|
| Platinum Member |
How to match the segment names and DB table names in the cluster join master (or multi-segment synonym)? I have looked into all internal tables as well. Any help? WF 7.7.02 on Windows 7 Teradata HTML,PDF,EXCEL,AHTML | |||
|
| Member |
Hi All, Any solution for the above mentioned issue?. By Veeramani WebFOCUS 8 Windows, All Outputs | |||
|
| Platinum Member |
If you need SEGMENT from the cluster masterfile you can use the column SEGNAME from SYSCOLUM table webFOCUS 8206 Windows 10 | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [Answered] Question: Report From .ACX Files?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [Answered] Question: Report From .ACX Files?Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |