APPX Query is bundled with APPX, and is automatically installed when APPX itself is installed. This document steps you through the process of configuring the APPX Query environment.

Following is an Overview of the 12 steps to configure APPX Query, followed by Detailed Instructions on each of the 12 steps.

For those who have installed this before, there are 'fast-track' instructions on configuring APPX Query.

If you are installing a new SQL registration, you will need to follow the Revising SQL Registration instructions.

If you have any questions about any of these steps please email us at support@appx..com, or phone in for technical support.

--------------------------------------------------------------------------------

Overview:
APPX Query is configured as follows:

Create an Application ID for APPX Query
Create an APPX Query Default Application ID.
Create Source Files for Application ID SQA.
Define the Databases/Applications Combination.
Create the Query manager ID - APX.
Link non-'00' versions of SQL Executables (SQL/vv).
Create APPX Query Data Files.
Attach APPX Query to a Menu.
Enter APPX Query Registration Number.
Enter Query Manager ID - APX.
Enter Default Application ID - SQA.
Enter Application ID's per user.
Detailed Instructions:
Create an Application ID for APPX Query.
From the Main Menu, select the following options:

  3) System Administration

  3) Databases/Applications

  1) Applications               

Application Test Database
ID Ver Description ID
--- --- ------------------------------ ---
SQL 00 APPX Query - Executables (leave blank)
APPX Query requires that you create this application with a version number of "00". If you maintain other versions of applications on your system and plan to access these applications via APPX Query, add an additional SQL application record (with the appropriate version number) for each application version. (i.e., SQL 99, SQL Applications - Version 99)

Application Test Database
ID Ver Description ID
--- --- ------------------------------ ---
SQA 00 APPX Query - Query Repository (leave blank)
Enter a default application record for each version, i.e., one record for each record created in the previous step. (i.e., SQA/99, SQL Default Application, Version 99).

Do Not Attempt to Select 5) Design File Management for SQL/00! Only for SQA/00!

Repeat this step to create the design files for any additional versions of SQA added in the previous steps.

Database Startup Application
ID Description ID Ver
--- ------------------------------ --- ---
Q00 SQL SQL 00

The Database ID must be the letter "Q" followed by the application version. (i.e., 'Qvv' where 'vv' is the version number.) Repeat this step for each version entered in previous steps.

There are no additional "Related Applications" for this entry (other that the default entry of SQL, automatically generated).

NOTE: A Database ID of "Q00" is mandatory.

  3) System Administration

  4) Security

  1) Users

Create a user with a User ID of 'APX', who will be defined during the Registration process as the APPX Query Manager. (You may want to may the User 'System ID' of "appx", which is not normally otherwise used as an active User ID, the APX.) Immediately after entering the information below, you will be prompted to enter a Security Profile for User APX. A User Profile must exist before any user can be created. For further information regarding User Profiles, refer to the APPX System Administration manual.

Create the User ID with the following information:

User Sys System Alpha
ID Adm Name ID Sort
--- --- ------------------------------ -------- ------
APX N SQL Query Manager appx SQLMGR

NOTE: You must also create an Operating System ID for user APX.
Link non-'00' versions of SQL Executables (00/SQL):
If you have versions of an application (other than version 00) which will access APPX Query, exit to the System Prompt, become User ID 'appx' and type the following:

cd $APPXPATH/## (where ## equals the version number)
ln -s ../00/SQL SQL
ls -al SQL

Repeat this step for each version. Then exit from being User ID 'appx'.

If you are working from a platform that doesn't support Symbolic Linking (such as MS Windows), you can manually copy the $APPXPATH/00/SQL directory tree to $APPXPATH/vv/SQL, but this will require an additional 3 megs of disk, per version so copied.

Database Q00
Application SQL

(If you are running under VAX/VMS operating system, use 2) File Specifications to modify the file sizes to the recommended sizes below.)

USER and DRAWER Number of APPX Query Users.
QUERY Number of APPX Query users times the average

                  number of saved queries per user.

                  1/4 of the file size for the APPX Query file.

If you are using non-'00' version numbers, it is necessary to create the APPX Query data files for each non-00 combination of Database/Applications entered in step 4 above.

  2) Application Design

  2) Process management

  1) Menus

To access APPX Query from an Application, create a new menu or attach a new option to an existing menu as follows:

                   Process    Process

Enter the Release Number, Expiration Date, and your APPX Query registration number (which is separate from, but tied to, your APPX registration).

If you do not have an APPX Query registration, please call APPX Software to acquire one.

A special User ID is designated as the APPX "Query Manager". The Query Manager has access to special APPX Query management functions.

All "common" queries (queries shared by all users) will be owned by this User ID. The Query Manager will be the only user who can modify these common queries. This user will not own any "personal" queries.

It is recommended that this User ID be used only by specified individuals and only when it is necessary to perform those operations reserved for the APPX Query Manager.

Queries for all APPX Query users are stored under a designated Application ID. Because the Default Application ID is being specified here, it will not be necessary to enter an Application ID for specific users (see next step).

(By answering "Y" to this question, Queries will be stored under each user's 3-letter APPX User ID. . (???))
After completing the registration information, you will return to the menu previously accessed. The next time you attempt to run APPX Query, the APPX Query main menu will display. An online tutorial will walk you through using APPX Query.

'Fast-Track' Configuration Instructions ... ... for those of you who have done this before, and just need a quick 'cheat sheet' to do it again.

Enter APPLICATION record for "SQL/00" (or SQL/vv), leaving Test ID blank.
Enter APPLICATION record for "SQA/00" (or SQA/vv), leaving Test ID blank.
Run 5)Design File Mgmt, 3)Create Files for SQA/00 (or SQA/vv).
Create DATABASE 'Q00' (or Qvv), with a Startup Application of SQL/00 (or SQL/vv).
Set up a user to be "APPX Query Manager" (APX).
Logon ID 'appx' is a good choice. Set the 3-letter APPX User ID in Security equal to 'APX'.
Link non-'00' versions of SQL Executables (SQL/vv):
cd $APPXPATH/vv
ln -s ../00/SQL SQL
Enter 4)Database Management for Q00/SQL (Qvv/SQL), then 3)Create Files.
Create Link to SQL from one of your Application Menus:
Application ID = SQL, Process Type = INPUT, Process Name = 'APPX SQL'.
Enter APPX Query Registration Number.
Enter Query Manager ID = APX.
Enter Default Application ID = SQA.
Application ID's for specific users? = 'N'.

For each Version# "vv" under which you are running SQL, perform the following:
.
cd $APPXPATH
cd Qvv/SQL/Data
(if version#=00, then this is Q00/SQL/Data.)
mv PARAM.dat PARAM.bk
.
Go into "4) Database Management" for Database='Qvv', Application='SQL'. Run "3) Create Files".

Using your SQL Registration information (obtained from APPX Software), enter your APPX Query Registration Number.
Enter Query Manager ID = APX.
Enter Default Application ID = SQA.
Application ID's for specific users? = 'N'.