I know we get the FILE info from SYSCOLUM and how to do that. But, I cannot remember where to get the data for the ACX files and FOCEXECs? Who Knows? Thanks in advance for passing it on...

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

SYSFILES will give you all the MASTER files.

APP LIST HOLD will create the FOCAPPL file which lists all the APP directories

APP QUERY directorylist HOLD will create the FOCAPPQ file which lists all the files in the applications of the directorylist

Thanks for that info. But, what I'm looking for is something within WebFOCUS that provides the info for ACX files and FOCEXECs similar to that information provided from SYSCOLUM for the MFDs, as follows:

TBNAME TBTYPE SEGNO SEGNAME SEGTYPE LOCSEGNAME SKEYS FILENAME NAME     COLNO COLTYPE LENGTH 
CAR    FOC        1 ORIGIN  S       ORIGIN         1 CAR      COUNTRY      1 CHAR        10 
CAR    FOC        2 COMP    S       COMP           1 CAR      CAR          2 CHAR        16  etc...

I know that I can do some various DOS commands on the App Folders and read the directory of fexes and the the fexes themselves and I just may do that. But, is that info available within WebFOCUS for the ACX / FOCEXECs like that of SYSCOLUM? ... Yes: , No: ...

SYSFILES will give you any type of file.

SQL FMI SET SYSFILES ACCESS
TABLE FILE SYSFILES
PRINT *
END

As for ACX file info, not sure how much, but some is accessed from SYSTABLE

Thanks Waz, that tells me about the files. But, I want the contents of those files... I'll just make a fex to read the acx and fex files... -READ or something like that...

As mentioned, some of the info is found when you table SYSTABLE.

e.g.

SERVER
REALNAME

Actually, there IS something to show you the contents of the ACX and FEX files. Right click and chose Edit in Textfor stating the obvious, but it seems like you're going to a lot of trouble for something that already has an easy solution. If you don't want to know about the files, but rather their contents, it sounds like you want a focexec to read a focexec - which doesn't make much sense unless you're trying to get around restrictions that limit what you can currently see.

I’m sorry that I did not explain myself clearly enough… So, I’ll try again.

First off, this was spurred on by the post regarding documentation a while back.
Secondly, the below code

TABLE FILE SYSCOLUM
PRINT TBNAME TBTYPE …
WHERE TBNAME EQ 'MyFile'
END

provides the “contents” of “MyFile” via “TABLE FILE SYSCOLUM” … WHERE TBNAME EQ ‘MyFile’

Now, finally, I am wondering (and doubtfully so, imho) if there is something out in WebFOCUS Land such as “TABLE FILE FEXFILES” which would work something like this:

TABLE FILE FEXFILES” … PRINT FEXLINE … WHERE FEXNAME EQ ‘MyFex’

Now, I do know how to do this using a created MFD and associated FILEDEFs, MacGyver stuff, etc… But, I just don’t want to “reinvent the wheel” again if there’s already a wheel out there that does what I want…

Thanks again...

I do all of that by hand, i.e. a generic master.

There isn't really anything like that. The fex files under MRE (at least for now) don't exists in any sort of structure that could be read like. They are just text files buried under the basedir directory.

For files in the server's application path there are a couple of statements that get you part way there that you may want to chekc out.

APP LIST [HOLD] lists the applications under approot. The HOLD option creates focappl.ftm which you can then write a report against.

APP QUERY app [HOLD] lists all the files under the specified location. The HOLD option creates focappq.ftm. You could then report against that hold file selection only thoses record where the filename contains ".fex".

Maybe those would be of some help...

The only thing that would come close as automated, would be the Impace Analysis functions on the WF server.

Thanks Everyone...

I'll do something with the "generic master" and the "focapp*" files... I'll get back to this later and close it for now.

Thanks Again,
Doug