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,

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.

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

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.

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}'
END

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  

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.

glad we could help
#transhemispherical_fistbump!

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?

Hi All,

Any solution for the above mentioned issue?.

By Veeramani

If you need SEGMENT from the cluster masterfile you can use the column SEGNAME from SYSCOLUM table