Focal Point
[CLOSED] FOQAPPQ assistance
January 06, 2011, 08:07 AM
ABT [CLOSED] FOQAPPQ assistance
I ran across this post yesterday (https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6431032491) and it seems like something I have been trying to do since I first began with Focus (about a year ago).
My tests with FOQAPPQ show no results (table appears empty). Is there something I have to do to load or initialize it? "Turn it on"?
- ABT
This message has been edited. Last edited by: Kerry , January 14, 2011 10:31 AM ------------------------------------ WF Environment: ------------------------------------ Server/Client, ReportCaster, Dev Studio: 7.6.11 Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist OS: Windows Server 2003 Application/Web Server: Tomcat 5.5.25 Java: JDK 1.6.0_03 Authentication: LDAP, MRREALM Driver Output: PDF, EXL2K, HTM ------------------------------------ Databases: ------------------------------------ Oracle 10g DB2 (AS/400) MSSQL Server 2005 Access/FoxPro
January 06, 2011, 09:58 AM
Gizmo You do have to issue an APP QUERY comand with the HOLD option to populate the FOCAPPQ table.
APP QUERY BASEAPP HOLD
TABLE FILE FOCAPPQ
PRINT *
END
Windows: WF 7.6.2: SQL Server 2008 R2 January 06, 2011, 10:19 AM
ABT When I tried yesterday, I was using the windows path to the baseapp folder, not the application name (duh - makes sense now). :-)
That's good for application folders, but how about MR domains (c:\ibi\WebFocus768\basedir\*)?
- ABT
------------------------------------ WF Environment: ------------------------------------ Server/Client, ReportCaster, Dev Studio: 7.6.11 Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist OS: Windows Server 2003 Application/Web Server: Tomcat 5.5.25 Java: JDK 1.6.0_03 Authentication: LDAP, MRREALM Driver Output: PDF, EXL2K, HTM ------------------------------------ Databases: ------------------------------------ Oracle 10g DB2 (AS/400) MSSQL Server 2005 Access/FoxPro
January 06, 2011, 05:16 PM
Gizmo quote:
That's good for application folders, but how about MR domains (c:\ibi\WebFocus768\basedir\*)? - ABT
That is where APP MAP comes into play
Windows: WF 7.6.2: SQL Server 2008 R2