 |
|||||
|
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. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| [SOLVED] SYSCOLUM for FILES | Login/Join |
| Expert |
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, | ||
|
| Virtuoso |
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 Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF | |||
|
| Expert |
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:  ... | |||
|
| Expert |
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 Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
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... | |||
|
| Expert |
As mentioned, some of the info is found when you table SYSTABLE. e.g. SERVER REALNAME Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Virtuoso |
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. Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Expert |
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' ENDprovides 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... | |||
|
| Expert |
I do all of that by hand, i.e. a generic master. Ginny --------------------------------- Prod: WF 7.7.01 Dev: WF 7.6.9-11 Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google | |||
|
| Virtuoso |
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... Regards, Darin In FOCUS since 1991 WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex WF Client: 77 on Linux w/Tomcat | |||
|
| Expert |
The only thing that would come close as automated, would be the Impace Analysis functions on the WF server. Waz...
| |||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
| Expert |
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
| |||||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 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 |