COPYRIGHT/LICENSE/WARRANTY
This software and accompanying files are Products of TEXTILE COMPUTER
SYSTEMS INC (USA).
LICENSE AGREEMENT
You should carefully read the following terms and conditions before
using this software. Your use of this software indicates your
acceptance of this license agreement and warranty.
You agree not to copy, modify, transmit or reverse engineer this
software. Also you agree not to use this software for any purpose
or in any manner other than for which it is expressly provided.
One single user version copy may either be used only by a single
person who uses the software personally on one or more computers,
or installed on a single workstation used nonsimultaneously by
multiple people, but not both.
One single network version may be used on one or more computers
simultaneously installed on a single workstation.
One multiple network version may be used on one or more computers
simultaneously installed on more than a single workstation upto
the number of networks specified in the multiple network version
license.
You also agree to remove the demo software and the related documents
from all the computers immediately after 30 days from the date of
receipt of the demo software and return the demo software to TEXTILE
COMPUTER SYSTEMS INC (USA).
GOVERNING LAW
This agreement shall be governed by the laws of the State of Texas,
USA.
DISCLAIMER OF WARRANTY
THIS SOFTWARE AND THE ACCOMPANYING FILES ARE SOLD "AS IS" AND WITH-
OUT WARRANTIES AS TO PERFORMANCE OF MERCHANTABILITY OR ANY OTHER
WARRANTIES WHETHER EXPRESSED OR IMPLIED. Because of the various
hardware and software environments into which this software may be
put, NO WARRANTY OF FITNESS FOR A PARTICULAR PURPOSE IS OFFERED.
Good data processing procedure dictates that any software be thoro-
ughly tested with non-critical data before relying on it. The
user must assume the entire risk of using this software. ANY LI-
ABILITY OF THE SELLER WILL BE LIMITED EXCLUSIVELY TO PRODUCT REPLACE-
MENT OR REFUND OF PURCHASE OR CURRENT MARKET PRICE WHICH EVER IS
LOWER UPTO US$100.
If you do not completely agree with the above "COPYRIGHT/LICENSE/
WARRANTY" information, please return the software without installing
it.
One of the most important source of information for system analysts and programmers,
who develop and maintain computer based systems is the cross reference information
between all the individual modules used in the system. Because of this kind of
information is not available for a system based on SQRs, the productivity of system
analysts and programmer are cosiderably less and so the cost of maintaining these
systems are very high. For example when a new SQR is developed or a system based
on SQRs is upgraded it is imperative to know all the SQRs that use a particular table,
procedure or include file. We may be able to find this information through a search
tool, but the problem is that these search tools are not a procedural language tools and
any logic in the search cannot be added or the define statements cannot be expanded or
the search path for the include files cannot be set etc. Because of this the results
may be wrong, miss leading or inadequate. Many times it may be more harmful than being
helpful when analysis is based on wrong information. It is also very important to
know the procedure flow in each SQR, to know the historical execution information
including the time of execution, platform and the database on which the SQRs were
executed etc. Moreover it is very important to get all the above needed information
in form of formatted reports or through interacive online panels.
SQR Multi Cross Reference tools addresses the above problems and make maintenance,
development or upgrading process of any systems based on SQRs faster, easier and cost
effective. The objective of this tool is to provide the needed Multi Cross Reference
information between all SQRs within the system both through printed reports and through
interactive online panels. Following are the needed reports to provide all the
needed Multi Cross Reference information:
To install the software the following 3 Install files are needed:
1. README.TXT
2. INSTXREF.EXE
3. INSSQRXF.SQT
Following are the steps to install the software:
1. Using any text editor, read "README.TXT" file
to get the instructions to install the software.
2. Note down the name of the folder where SQR Executeable
file is residing. This information is needed when
installing the software.
3. Close down all the currently running application software.
4. Move the above mentioned 3 Install files into an empty
folder.
5. Run MS-DOS by selecting "MS-DOS Prompt" under "Programs"
from "Start" button.
6. Change to the folder where the 3 Install files were
moved.
7. At MS-DOS prompt type INSTXREF which will execute the
SQR Install program.
8. Follow the instructions provided by the SQR Install
Porgram. (Use F1 to get help). The actual Installation
of the Software may take about 25 - 35 minutes depending
on the speed of the processor and the SQR Tools' modules are
to be installed.
NOTE: Complete connectivity information should be entered
in the SQR Installer. Following are the examples
for different RDBMS systems:
Allbase: Database.
This is the name of the database to use.
DB2 Ssname/SQLid.
This is the subsystem name and SQL
authorization id to use.
Informix Database.
This is the name of the database to use
Ingres Database[/STAR][/Username].
This is the name of the database to use
and an optional user name.
Oracle [Username]/[Password[@Database]].
This is the username and password for the
database. Optionally, you can can
specify the connection string for the
database (e.g. @B:ORASERVER).
Rdb None
SQLBase [Database]/[Username]/[Password].
This is the name of the database to use,
your user name and password for the
database.
Sybase Username/[Password].
This is your username and password for
the password for the database.
ODBC DataSource/[Username]/[Password]
This if the name of the ODBC's
DataSource, your user name and password
for the ODBC driver.
Please refer to SQR Manual to get more information regarding
connectivity.
When the SQR Tools software is installed successfully, a successful message
will be displayed. After quitting the installer program check for the following
files in the current folder where the 3 install files were moved:
1. XFSM (sub directory)
Files under XFSES sub directory:
A. XFS*010.SQT where * denotes the name of RDBMS
which could have any one of the following
values:
A = ALLBASE
D = DB2
I = INFORMIX
G = INGRES
M = MICROSOFT SQLSERVER
O = ORACLE
R = RDB
Q = SQLBASE
S = SYBASE
B. XFS*010D.SQT where * denotes the name of RDBMS
which could have any one of the following
values:
A = ALLBASE
D = DB2
I = INFORMIX
G = INGRES
M = MICROSOFT SQLSERVER
O = ORACLE
R = RDB
Q = SQLBASE
S = SYBASE
C. XFSINCL.SQC.
D. READMEM.TXT which gives instructions to run
SQR Expander Program.
E. XFSM.DAT which has default parameters to run
SQR Multi Cross Reference Program.
The values in this file may have to be
changed to your needs.
F. XFSQR.LST which has the names of SQRs that have to
be added into the SQR Multi Cross Reference System.
This file has to be maintained on an on-going basis.
2. SQRM.DAT
This file contains the minimum sizes to be assigned
to various internal parameters before running the
installed SQTs. This file could be used with
-M flag before running the installed SQTs. To get
more information about -M flag refer to your SQR manual.
Also the values assigned to various internal parameters
in this file could be used as minimum values in your
existing -M file.
3. Also make sure that the following sub directories are created:
XFE
XFL
TEMP
Restart the computer.
If you have any questions in installing the SQR Tools Software or running them,
please contact the developer TCS INC via email tcscad@stic.net or info@tcssoft.com.
The SQR Multi Cross Reference System consists of XFS*010.SQT and XFS*010D.SQT
programs. XFS*010.SQT is a batch program that loads the SQR into the system and
XFS*010D.SQT is an online program that displays the data through online panels.
The SQR Multi Cross Reference Batch (XFS*010.SQT) program is an SQR Report
file and so could be executed only thorough SQR. Since this is a Report file
the SQR flag option '-RT' should be used to run this program. The SQR
Multi Cross Reference Batch program reads the SQR Multi Cross Reference
Initialization file once, at the beginning of the program. The name of this
initialization file is 'XFSM.DAT'. If this initialization file does not exist in
the current folder when the SQR was executed, then a window as shown in Figure 1
would be presented to the user so that the name of the folder where the initialization
file exists could be entered. At this point the user either enter the name of the
folder or enter 'Q' to quit the program. If the initialization file does
not exist in the folder entered by the user then the program would keep asking
for the correct folder's name.
____________________________________________________________________
|SQR Cross Reference Initialization's Folder Name; Q=Quit: |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|__________________________________________________________________|
FIGURE 1
The initialization file contains vital information required by the
SQR Multi Cross Reference programs and should be updated before running the SQR
Multi Cross Reference programs. The SQR Multi Cross Reference batch program
reads the following information from the initialization file:
1. TABLE01: The name of one of the tables used by the Multi Cross
Reference System. This name could be anything to suit
the user's stanadards. Following are the structure
details of this table:
XFSF_SQRNAME CHAR 15
XFSF_DATETIME CHAR 14
XFSF_DESCL CHAR 150
XFSF_DESCS CHAR 15
XFSF_YNTYPE CHAR 1
XFSF_PATHNAME CHAR 100
XFSF_EXECTRACK CHAR 1
XFSF_ACTNAME CHAR 15
PRIMARY KEY: XFSF_SQRNAME
2. TABLE02: The name of one of the tables used by the Multi Cross
Reference System. This name could be anything to suit
the user's stanadards. Following are the structure
details of this table:
XFSF_SQCNAME CHAR 15
XFSF_DESCL CHAR 150
XFSF_DESCS CHAR 15
XFSF_PATHNAME CHAR 100
PRIMARY KEY: XFSF_SQCNAME
3. TABLE03: The name of one of the tables used by the Multi Cross
Reference System. This name could be anything to suit
the user's stanadards. Following are the structure
details of this table:
XFSF_SQRNAME CHAR 15
XFSF_TOTAL NUMBER 3
XFSF_SQCNAME CHAR 15
XFSF_LVL1NAME CHAR 30
XFSF_LVL2NAME CHAR 30
XFSF_LVL3NAME CHAR 30
XFSF_LVL4NAME CHAR 30
XFSF_LVL5NAME CHAR 30
XFSF_LVL6NAME CHAR 30
XFSF_INCLREQ CHAR 1
PRIMARY KEY: XFSF_SQRNAME, XFSF_TOTAL,
XFSF_SQCNAME,XFSF_LVL1NAME,
XFSF_LVL2NAME, XFSF_LVL3NAME,
XFSF_LVL4NAME, XFSF_LVL5NAME,
XFSF_LVL6NAME
4. TABLE04: The name of one of the tables used by the Multi Cross
Reference System. This name could be anything to suit
the user's stanadards. Following are the structure
details of this table:
XFSF_SQCNAME CHAR 15
XFSF_TOTAL NUMBER 3
XFSF_SQRNAME CHAR 15
XFSF_LVL1NAME CHAR 30
XFSF_LVL2NAME CHAR 30
XFSF_LVL3NAME CHAR 30
XFSF_LVL4NAME CHAR 30
XFSF_LVL5NAME CHAR 30
XFSF_LVL6NAME CHAR 30
XFSF_INCLREQ CHAR 1
PRIMARY KEY: XFSF_SQCNAME, XFSF_TOTAL,
XFSF_SQRNAME, XFSF_LVL1NAME,
XFSF_LVL2NAME, XFSF_LVL3NAME,
XFSF_LVL4NAME, XFSF_LVL5NAME,
XFSF_LVL6NAME
5. TABLE05: The name of one of the tables used by the Multi Cross
Reference System. This name could be anything to suit
the user's stanadards. Following are the structure
details of this table:
XFSF_SQCNAME CHAR 15
XFSF_SQRNAME CHAR 15
XFSF_TABLENAME CHAR 35
XFSF_PSEUDONAME CHAR 35
XFSF_TYPE CHAR 1
PRIMARY KEY: XFSF_SQCNAME, XFSF_SQRNAME,
XFSF_TABLENAME,
XFSF_PSEUDONAME, XFSF_TYPE
ALTERNATE KEY: XFSF_TABLENAME
6. TABLE06: The name of one of the tables used by the Multi Cross
Reference System. This name could be anything to suit
the user's stanadards. Following are the structure
details of this table:
XFSF_SQCNAME CHAR 15
XFSF_SQRNAME CHAR 15
XFSF_PROCNAMES CHAR 50
XFSF_PROCNAMEL CHAR 120
PRIMARY KEY: XFSF_SQCNAME, XFSF_SQRNAME,
XFSF_PROCNAMES, XFSF_PROCNAMEL
ALTERNATE KEY: XFSF_PROCNAMES
7. TABLE07: The name of one of the tables used by the Multi Cross
Reference System. This name could be anything to suit
the user's stanadards. Following are the structure
details of this table:
XFSF_SQRNAME CHAR 15
XFSF_COUNT NUMBER 6
XFSF_RDBMS CHAR 35
XFSF_USERNAME CHAR 35
XFSF_PLATFORM CHAR 35
XFSF_STARTDATETIME CHAR 14
XFSF_ENDDATETIME CHAR 14
XFSF_TYPE CHAR 1
XFSF_TIME CHAR 5
PRIMARY KEY: XFSF_SQRNAME, XFSF_COUNT
8. TABLE08: The name of one of the tables used by the Multi Cross
Reference System. This name could be anything to suit
the user's stanadards. Following are the structure
details of this table:
XFSF_SQRNAME CHAR 15
XFSF_COUNT NUMBER 6
XFSF_TOTAL NUMBER 3
XFSF_PROCNAMES CHAR 50
XFSF_PROCNAMEL CHAR 150
PRIMARY KEY: XFSF_SQRNAME, XFSF_COUNT
9. SQRFOLDER: These are the folders, from which the SQR main source
file could be pulled from. The order of search
for the SQR main source file are the order in which
the SQRFOLDERs are entered in the initialization file.
The Multi Cross Reference System would look first in the
first SQRFOLDER, then the next SQRFOLDER and so on.
10. INCLFOLDER: These are the folders, from which the included files
could be pulled from. The order of search for the
included files are the order in which the INCLFOLDERs
are entered in the initialization file. The Interactive
Debugger would look first in the first INCLFOLDER, then
the next INCLFOLDER and so on.
11. INPUTFOLDER: The names of the SQRs which are to be loaded or to be
deleted from the SQR Multi Cross Reference system
are entered into a file called 'XFSQR.LST'. This file
could exist in any folder and the name of the folder in
which this file exists is entered here.
12. XFEFOLDER: This is the name of the folder in which the expanded SQR
files would be saved. An expanded file is created for
each selected SQR. The name of the expanded file is
primary name of the SQR file plus '.XFE'.
13. XFLFOLDER: This is the name of the folder in which the list files
would be saved. A list file is created for each
selected SQR. The name of the list file is primary
name of the SQR file plus '.XFL'.
14. TEMPFOLDER: This is the name of the folder in which the temporary
files would be saved.
15. CREATETABLE: When the value for this flag to set to 'Y' then the
needed tables for the SQR Multi Cross Reference system
will be created. After creating the tables it could be
set to 'N', so that the tabels will not be created again.
Also if it is desired to create the tables outside this
SQR then they could be created and this flag could be set
to 'N', before running this SQR.
16. ADDCODE: When the value for this flag to set to 'Y' then nccessary
code to generate and save SQR execution information will be
added. When the value for this flag to set to 'R' then
nccessary code that were added to generate and save SQR
execution information will be removed.
17. WRITEXFE: When an SQR is added to the Multi Cross Reference System an
expanded file for the added SQR will be created when this
flag is set to 'Y'.
18. WRITEXFL: When an SQR is added to the Multi Cross Reference System a
list file for the added SQR will be created when this
flag is set to 'Y'.
Following is contents of a sample SQR Multi Cross Reference initialization file:
TABLE01 = 'XFST_TABLE01'
TABLE02 = 'XFST_TABLE02'
TABLE03 = 'XFST_TABLE03'
TABLE04 = 'XFST_TABLE04'
TABLE01 = 'XFST_TABLE01'
TABLE02 = 'XFST_TABLE02'
TABLE03 = 'XFST_TABLE03'
TABLE04 = 'XFST_TABLE04'
SQRFOLDER = 'C:\SQR\PAYROLL\SOURCE\TEST\'
SQRFOLDER = 'C:\SQR\PAYROLL\SOURCE\STAGE\'
SQRFOLDER = 'C:\SQR\PAYROLL\SOURCE\PROD\'
INCLFOLDER = 'C:\INCLUDE\PAYROLL\SOURCE\TEST\'
INCLFOLDER = 'C:\INCLUDE\PAYROLL\SOURCE\STAGE\'
INCLFOLDER = 'C:\INCLUDE\PAYROLL\SOURCE\PROD\'
INPUTFOLDER = 'C:\INS\XFSM\'
XFEFOLDER = 'C:\INS\XFE\'
XFLFOLDER = 'C:\INS\XFL\'
TEMPFOLDER = 'C:\INS\TEMP\'
CREATETABLE = 'N'
ADDCODE = 'Y'
WRITEXFE = 'N'
WRITEXFL = 'N'
The value for the variables in the initialization file are provided
within single quotes. They can be changed by the user to suit their needs.
For example the names for the SQRFOLDER could be anything, and so could be according
to the standards of the individual user.
Following is contents of a sample 'XFSQR.LST' file, which for the
above example should reside inside the folder 'C:\INS\XFSM\':
SQR011.SQR
LDTBLS.SQR
SQR085.SQR
SQR006.SQR
When the SQR Multi Cross Reference Batch program (XFS*010.SQT) program is submitted
for execution through SQR, the initialization file would be read.
Once the needed information from the initialization file is read, a window as shown in
Figure 2 would be presented to the user so that the user can select an option, if the
flag for "CREATETABLE" is set to 'Y' and the needed tables already exist in the database.
____________________________________________________________________
|Customer: My Comapny Name |
|Program: c:\ins\xfsm\xfso010.sqt |
|Name for Table TABLE01: XFST_TABLE01 |
|Name for Table TABLE02: XFST_TABLE02 |
|Name for Table TABLE03: XFST_TABLE03 |
|Name for Table TABLE04: XFST_TABLE04 |
|Name for Table TABLE05: XFST_TABLE05 |
|Name for Table TABLE06: XFST_TABLE06 |
|Name for Table TABLE07: XFST_TABLE07 |
|Name for Table TABLE08: XFST_TABLE08 |
|No. of SQR Search Folders: 3.00000 |
|SQR Folder (SQRFOLDER) 1: C:\SQR\PAYROLL\SOURCE\TEST\ |
|SQR Folder (SQRFOLDER) 2: C:\SQR\PAYROLL\SOURCE\STAGE\ |
|SQR Folder (SQRFOLDER) 3: C:\SQR\PAYROLL\SOURCE\PROD\ |
|Include Folder (INCLFOLDER) 1: C:\INCLUDE\PAYROLL\SOURCE\TEST\ |
|Include Folder (INCLFOLDER) 2: C:\INCLUDE\PAYROLL\SOURCE\STAGE\ |
|Include Folder (INCLFOLDER) 3: C:\INCLUDE\PAYROLL\SOURCE\PROD\ |
|Input File Folder (INPUTFOLDER): C:\INS\XFSM\ |
|Expand File Folder (XFEFOLDER): C:\INS\XFE\ |
|List File Folder (XFLFOLDER): C:\INS\XFL\ |
|Temporary File Folder (TEMPFOLDER): C:\INS\TEMP\ |
|Add Code (ADDCODE Y/N): Y |
|Create Table (CREATETABLE Y/N): Y |
|Write Expand File (WRITEXFE Y/N): N |
|Write List File (WRITEXFL Y/N): N |
|Do you really want to recreate the Tables (Y/N): |
| |
|__________________________________________________________________|
FIGURE 2
At this point the appropriate available options for the users are 'Y' , or
'N'. The input could be in upper or lower case. If the user's option is 'Y'
then the needed tables will be recreated. If the user's option is 'N' then the
tables will not be recreated. Then the execution of the program will continue.
Once the needed information from the initialization file is read, a window
as shown in Figure 3 would be presented to the user so that the user can select an
option, if the flag for "CREATETABLE" is set to 'N' and the needed tables do not exist
in the database.
____________________________________________________________________
|Customer: My Comapny Name |
|Program: c:\ins\xfsm\xfso010.sqt |
|Name for Table TABLE01: XFST_TABLE01 |
|Name for Table TABLE02: XFST_TABLE02 |
|Name for Table TABLE03: XFST_TABLE03 |
|Name for Table TABLE04: XFST_TABLE04 |
|Name for Table TABLE05: XFST_TABLE05 |
|Name for Table TABLE06: XFST_TABLE06 |
|Name for Table TABLE07: XFST_TABLE07 |
|Name for Table TABLE08: XFST_TABLE08 |
|No. of SQR Search Folders: 3.00000 |
|SQR Folder (SQRFOLDER) 1: C:\SQR\PAYROLL\SOURCE\TEST\ |
|SQR Folder (SQRFOLDER) 2: C:\SQR\PAYROLL\SOURCE\STAGE\ |
|SQR Folder (SQRFOLDER) 3: C:\SQR\PAYROLL\SOURCE\PROD\ |
|Include Folder (INCLFOLDER) 1: C:\INCLUDE\PAYROLL\SOURCE\TEST\ |
|Include Folder (INCLFOLDER) 2: C:\INCLUDE\PAYROLL\SOURCE\STAGE\ |
|Include Folder (INCLFOLDER) 3: C:\INCLUDE\PAYROLL\SOURCE\PROD\ |
|Input File Folder (INPUTFOLDER): C:\INS\XFSM\ |
|Expand File Folder (XFEFOLDER): C:\INS\XFE\ |
|List File Folder (XFLFOLDER): C:\INS\XFL\ |
|Temporary File Folder (TEMPFOLDER): C:\INS\TEMP\ |
|Add Code (ADDCODE Y/N): Y |
|Create Table (CREATETABLE Y/N): N |
|Write Expand File (WRITEXFE Y/N): N |
|Write List File (WRITEXFL Y/N): N |
|Can the Tables be created (Y/N): |
| |
|__________________________________________________________________|
FIGURE 3
At this point the appropriate available options for the users are 'Y' , or
'N'. The input could be in upper or lower case. If the user's option is 'Y'
then the needed tables will be created. If the user's option is 'N' then the
tables will not be created the execution of the program will terminate.
After validating the data and if the required tables exist, a window as shown in
Figure 4 will be presented to the user.
____________________________________________________________________
|1=Load; 2=Analyze; 4=Print; 5=Reanalyze; Q=Quit: |
| |
|__________________________________________________________________|
FIGURE 4
At this point the appropriate available options for the users are '1', '2', '3',
'4', '5', '6', '7', '9' or 'Q'. The input could be in upper or lower case.
1: The SQRs listed in the list file ('XFSQR.DAT') will be loaded
into the SQR Multi Cross Reference System. If flag 'D' is
set after the name of the SQR then those SQRs will be delted
from the SQR Multi Cross Reference System. Also the loaded
SQRs will be set in the system as not been analyzed.
2: Any SQRs that have not been analyzed in the system will be
analyzed. Analysis means that an expanded file will be created,
if appropriate flags are set up, a compiler list file will be
created, if appropriate flags are set up, and all the required
information for Multi Cross Reference System pertaining to each
SQR will be added into the system. This information will be
used to retrieve SQR Multi Cross Reference Information for online
viewing.
The expanded SQR files (in the above example SQR011.XFE,
LDTBLS.XFE,SQR085.XFE and SQR006.XFE) would be saved in
'C:\INS\XFE\'.
The compiler list file would be saved in (in the above example
SQR011.XFL, LDTBLS.XFL, SQR085.XFL and SQR006.XFL) 'C:\INS\XFL\'.
This compiler listing consists of the following information:
A. Listing of all the files used in the SQR with line
numbers in the expanded file and line numbers in the
individual file.
B. Names of the files used in the SQR and their Folder's
name and the included files that are not needed are
highlighted.
C. Tree Structure of Procedures Used in the SQR
D. Procedures Declared in the SQR
E. Tables used in the SQR and the mode in which they were
used
F. Variable Listing used in the SQR
G. Warning Error Messages
3: This is same as entering options 1 and 2 spearately.
4: The following cross reference batch files will be printed:
5: All the SQRs loaded into the system, whether they been analyzed
or not, will be analyzed.
6: This is same as entering options 2 and 4 seperately.
7: This is same as entering options 1, 2 and 4 seperately.
9: This is same as entering options 4 and 5 seperately.
Once the initialization file is set up correctly, then only the contents of
'XFSQR.LST' file has to be changed on an on-going basis.
The SQR Multi Cross Reference Online (XFS*010D.SQT) program is an SQR Report
file and so could be executed only thorough SQR. Since this is a Report file
the SQR flag option '-RT' should be used to run this program. The SQR
Multi Cross Reference Online program reads the SQR Multi Cross Reference
Initialization file once, at the beginning of the program. The name of this
initialization file is 'XFSM.DAT'. If this initialization file does not exist in
the current folder when the SQR was executed, then a window as shown in Figure 1
would be presented to the user so that the name of the folder where the initialization
file exists could be entered. At this point the user either enter the name of the
folder or enter 'Q' to quit the program. If the initialization file does
not exist in the folder entered by the user then the program would keep asking
for the correct folder's name.
____________________________________________________________________
| SQR Cross Reference Information |
| Parameters Used |
| |
| Customer: My Comapny Name |
|Initialization File: XFSM.DAT |
|TABLE01: XFST_TABLE01 |
|TABLE02: XFST_TABLE02 |
|TABLE03: XFST_TABLE03 |
|TABLE04: XFST_TABLE04 |
|TABLE05: XFST_TABLE05 |
|TABLE06: XFST_TABLE06 |
|TABLE07: XFST_TABLE07 |
|TABLE08: XFST_TABLE08 |
| |
| |
| |
| |
| |
| |
| |
|Are the above mentioned parameters true (Y/N)? |
|Or Q to End: |
| |
|__________________________________________________________________|
FIGURE 5
The initialization file contains vital information required by the
SQR Multi Cross Reference Online program and should be updated before running
the SQR Multi Cross Reference Online program. The SQR Multi Cross Reference
Online program reads the necessary information for the 8 tables that are used by
SQR Multi Cross Reference System and so a window as displayed in Figure 5 will
be presented to the user to confirm the names of the tables being used. At this
point the appropriate available options for the users are 'Y', 'N', or 'Q'.
The input could be in upper or lower case. If the input is 'Y' a window as shown
in Figure 6 will be presented to the user otherwise the execution of the program will
terminate.
____________________________________________________________________
| SQR Cross Reference Information |
| Main Menu |
| |
| Customer: My Comapny Name |
| 1. SQR Files, Included Files, Tables & Declared Procedures |
| 2. SQR Files & Used Procedures |
| 3. Included Files, Tables, Declared Procedures & Path to SQR |
| 4. Declared Procedures, Parameters, Where Declared & Path to SQR|
| 5. Tables, Access Mode, Where Used & Path to SQR |
| 6. Execution Information By SQR |
| 7. Execution Information By Start Date & Time |
| Q. Quit |
| |
| Please Enter your choice: |
| |
| |
| |
|__________________________________________________________________|
FIGURE 6
At this point the appropriate available options for the users are '1',
'2', '3', '4', '5', '6', '7' or 'Q'. The input could be in upper or lower case.
1: A window as shown in Figure 7 will be presented to the user so
that more information about Included Files, Tables & Declared
Procedures for any selected SQR could be viewd.
2: A window as shown in Figure 12 will be presented to the user so
that more information about Used Procedures in any selected SQR
could be viewed.
3: A window as shown in Figure 14 will be presented to the user so
that list of Include Files and their path to all the SQRs could be
viewed. Also Tables and Declared Procedures in any selected
Include Files could be viewed.
4: A window as shown in Figure 19 will be presented to the user so
that list of Declared Procedures, their Parameters and Where Declared
and the path to SQR could be viewed.
5. A window as shown in Figure 21 will be presented to the user so
that list of Tables, their Access modes and Where Used and the
path to SQR could be viewed.
6. A window as shown in Figure 24 will be presented to the user so
that list of SQRs and their Execution Information for any selected
SQR could be viewed.
7. A window as shown in Figure 26 will be presented to the user so
that SQR Execution Information By Start Date and Time could be
viewed.
Q. Quit the program.
____________________________________________________________________________
| SQR Cross Reference Information |
| SQR Files, Included Files, Tables & Declared Procedures |
| Search String: ALL |
| Customer: My Comapny Name |
| SQR Name Anal Add Date & Time Added Folder |
| Code |
| |
| 1. EX10A.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 2. EX11A.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 3. EX12A.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 4. EX12B.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 5. EX12C.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 6. EX13A.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 7. EX14A.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 8. EX16A.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 9. EX16B.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 10. EX16C.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| |
| Q=Quit, P=Prev, N=Next, S=Search |
| Select Number (For Includes, Tables & Declared Procedures Information OR |
| Select Number + I (For Includes Information, Example: 1I) OR |
| Select Number + T (For Tables Information, Example : 1T) OR |
| Select Number + P (For Procedure Information, Example : 1P) |
| |
| Please Enter your chice: |
|__________________________________________________________________________|
FIGURE 7
At this point the appropriate available options for the users are a
valid number of the SQR to be selected, or a valid number of the SQR to be selected
+ I, or alid number of the SQR to be selected + T, or a valid number of the SQR to
be selected + P, or 'P', or 'N', or 'S' or 'Q'. The input could be in upper or
lower case.
Valid Number of the SQR (Example 5) A window as shown in
to selected: Figure 8 will be presented to the
user which will enable the user to
view includes, tables and procedure
information of the selected SQR.
Valid Number of the SQR (Example 5I) A window as shown in
to selected + I: Figure 9 will be presented to the
user which will enable the user to
view included files information in the
selected SQR.
Valid Number of the SQR (Example 5T) A window as shown in
to selected + T: Figure 10 will be presented to the
user which will enable the user to
view tables information of the
selected SQR.
Valid Number of the SQR (Example 5P) A window as shown in
to selected + P: Figure 11 will be presented to the
user which will enable the user to
view procedure information of the
selected SQR.
P: Only 10 SQR names are displayed in the
window as shown in Figure 7. This
option would display the previous
10 SQR Names, if any.
N: Only 10 SQR names are displayed in the
window as shown in Figure 7. This
option would display the next
10 SQR Names, if any.
S: SQR Names are displayed in alphabitical
ascending order as shown in Figure 7.
This option would help the user to view
the SQR names from a selected string.
Q: This option would bring up the window
as shown in Figure 6.
____________________________________________________________________________
| SQR Cross Reference Information |
| Included Files, Tables & Declared Procedures in LDTBLS.SQR |
| |
| Customer: My Comapny Name |
| 1. LDTBLS.SQR C:\DEMO\PROD\SQR\ |
| 2. XFSINCL.SQC C:\DEMO\PROD\SQC\ |
| 3. crldtbl.sqc C:\DEMO\PROD\SQC\ |
| 4. crtbl.sqc C:\DEMO\PROD\SQC\ |
| 5. ldtbl.sqc C:\DEMO\PROD\SQC\ |
| 6. DETAILS OF TABLES AND DECLARED PROCEDURES |
| 7. LDTBLS.SQR C:\DEMO\PROD\SQR\ |
| 8. Proc: BEGIN-REPORT( ) |
| 9. Proc: BEGIN-TABLE-TRAN( ) |
| 10. Proc: COMMIT-TABLE-TRAN( ) |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|__________________________________________________________________________|
FIGURE 8
Window as shown in Figure 8 displays Included Files, Tables & Declared
Procedures in a selected SQR in the following order:
1: Complete path information of the selected SQR
2: Included files, with complete path information, used in
the SQR. The included files are displayed with indentation
to show the complete route information from the SQR to each
individual included file.
3: Details of declared procedures, including list of parameters,
in each individual file, starting first from the SQR and then
in each included file.
4: Details of tables, including the access mode (R = READ,
I = INSERT, U = UPDATE, D = DELETE) in each individual file,
starting first from the SQR and then in each included file.
At this point the appropriate available options for the users are 'P',
or 'N', or 'Q'. The input could be in upper or lower case.
P: Only 10 lines of information are displayed in the window as
shown in Figure 8. This option would display the previous
10 lines of information, if any.
N: Only 10 lines of information are displayed in the window as
shown in Figure 8. This option would display the next 10
lines of information, if any. Hitting enter key without any
input is same as entering 'N'.
Q: This option would bring up the window as shown in Figure 7.
____________________________________________________________________________
| SQR Cross Reference Information |
| Included Files in LDTBLS.SQR |
| |
| Customer: My Comapny Name |
| 1. LDTBLS.SQR C:\DEMO\PROD\SQR\ |
| 2. XFSINCL.SQC C:\DEMO\PROD\SQC\ |
| 3. crldtbl.sqc C:\DEMO\PROD\SQC\ |
| 4. crtbl.sqc C:\DEMO\PROD\SQC\ |
| 5. ldtbl.sqc C:\DEMO\PROD\SQC\ |
| |
| |
| |
| |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|__________________________________________________________________________|
FIGURE 9
Window as shown in Figure 9 displays Included Files , with complete path
information, used in selected the SQR. The included files are displayed with
indentation to show the complete route information from the SQR to each individual
included file.
At this point the appropriate available options for the users are 'P',
or 'N', or 'Q'. The input could be in upper or lower case.
P: Only 10 lines of information are displayed in the window as
shown in Figure 9. This option would display the previous
10 lines of information, if any.
N: Only 10 lines of information are displayed in the window as
shown in Figure 9. This option would display the next 10
lines of information, if any. Hitting enter key without any
input is same as entering 'N'.
Q: This option would bring up the window as shown in Figure 7.
____________________________________________________________________________
| SQR Cross Reference Information |
| Included Files, Tables & Declared Procedures in LDTBLS.SQR |
| |
| Customer: My Comapny Name |
| 1. LDTBLS.SQR C:\DEMO\PROD\SQR\ |
| 2. DETAILS OF TABLES |
| 3. LDTBLS.SQR C:\DEMO\PROD\SQR\ |
| 4. XFSINCL.SQC C:\DEMO\PROD\SQC\ |
| 5. Table: [$WHICHTABLE] XFSTA R |
| 6. crldtbl.sqc C:\DEMO\PROD\SQC\ |
| 7. crtbl.sqc C:\DEMO\PROD\SQC\ |
| 8. ldtbl.sqc C:\DEMO\PROD\SQC\ |
| 9. Table: APPTS I |
| 10. Table: CASH_RECEIPTS I |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|__________________________________________________________________________|
FIGURE 10
Window as shown in Figure 10 displays details Tables used, including the
access mode (R = READ, I = INSERT, U = UPDATE, D = DELETE) in each individual file,
starting first from the SQR and then in each included file. It also displays the
psydonym used for the table, if the table is in read access mode.
At this point the appropriate available options for the users are 'P',
or 'N', or 'Q'. The input could be in upper or lower case.
P: Only 10 lines of information are displayed in the window as
shown in Figure 10. This option would display the previous
10 lines of information, if any.
N: Only 10 lines of information are displayed in the window as
shown in Figure 10. This option would display the next 10
lines of information, if any. Hitting enter key without any
input is same as entering 'N'.
Q: This option would bring up the window as shown in Figure 7.
____________________________________________________________________________
| SQR Cross Reference Information |
| Declared Procedures in LDTBLS.SQR |
| |
| Customer: My Comapny Name |
| 1. LDTBLS.SQR C:\DEMO\PROD\SQR\ |
| 2. DETAILS OF DECLARED PROCEDURES |
| 3. LDTBLS.SQR C:\DEMO\PROD\SQR\ |
| 4. Proc: BEGIN-REPORT( ) |
| 5. Proc: BEGIN-TABLE-TRAN( ) |
| 6. Proc: COMMIT-TABLE-TRAN( ) |
| 7. Proc: GET-USER-INPUT(:$USERCHOICE ) |
| 8. Proc: MAIN( ) |
| 9. XFSINCL.SQC C:\DEMO\PROD\SQC\ |
| 10. Proc: XFSC-BEGIN-TABLE-TRAN( ) |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|__________________________________________________________________________|
FIGURE 11
Window as shown in Figure 11 displays Declared Procedures, including list
of parameters, in each individual file, starting first from the SQR and then in each
included file.
At this point the appropriate available options for the users are 'P',
or 'N', or 'Q'. The input could be in upper or lower case.
P: Only 10 lines of information are displayed in the window as
shown in Figure 11. This option would display the previous
10 lines of information, if any.
N: Only 10 lines of information are displayed in the window as
shown in Figure 11. This option would display the next 10
lines of information, if any. Hitting enter key without any
input is same as entering 'N'.
Q: This option would bring up the window as shown in Figure 7.
____________________________________________________________________________
| SQR Cross Reference Information |
| SQR Files & Used Procedures |
| Search String: ALL |
| Customer: My Comapny Name |
| SQR Name Anal Add Date & Time Added Folder |
| Code |
| |
| 1. EX10A.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 2. EX11A.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 3. EX12A.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 4. EX12B.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 5. EX12C.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 6. EX13A.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 7. EX14A.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 8. EX16A.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 9. EX16B.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 10. EX16C.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| |
| Q=Quit, P=Prev, N=Next, S=Search |
| Select SQR File By Number for Information on Used Procedures |
| Please Enter your chice: |
|__________________________________________________________________________|
FIGURE 12
At this point the appropriate available options for the users are a
valid number of the SQR to be selected, or 'P', or 'N', or 'S' or 'Q'. The
input could be in upper or lower case.
Valid Number of the SQR (Example 5) A window as shown in
to selected: Figure 13 will be presented to the
user which will enable the user to
view used Procedures information in
the selected SQR. The information
would be displayed in the form of a
tree beginning from the first procedure
executed and all the procedures that
were called within each used procedure.
P: Only 10 SQR names are displayed in the
window as shown in Figure 7. This
option would display the previous
10 SQR Names, if any.
N: Only 10 SQR names are displayed in the
window as shown in Figure 7. This
option would display the next
10 SQR Names, if any.
S: SQR Names are displayed in alphabitical
ascending order as shown in Figure 7.
This option would help the user to view
the SQR names from a selected string.
Q: This option would bring up the window
as shown in Figure 6.
_____________________________________________________________________________
| SQR Cross Reference Information |
| Used Procedures in LDTBLS.SQR |
| |
| Customer: My Comapny Name |
| |
| 1. BEGIN-REPORT |
| 2. XFSC-SQR-EXECUTION('A_XFST_TABLE07',#XFSC-Instance,'Begin','ldtbls..|
| 3. XFSC-GET-CURR-DATETIME($XFSC-Date,$XFSC-Time,$XFSC-DateTime,$XSF..|
| 4. XFSC-CONVERT-TO-DEFAULTDATE('DD-MON-YYYY', $SysDate, $NewDate) |
| 5. XFSC-CONVERT-TO-DEFAULTTIME($SysTime, $NewTime) |
| 6. XFSC-GET-INSTANCE($WhichTable,$XFSC-SqrName,#WhichInstance) |
| 7. XFSC-BEGIN-TABLE-TRAN |
| 8. XFSC-COMMIT-TABLE-TRAN |
| 9. XFSC-BEGIN-TABLE-TRAN |
| 10. XFSC-COMMIT-TABLE-TRAN |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|___________________________________________________________________________|
FIGURE 13
At this point the appropriate available options for the users are a
valid number of the SQR to be selected, or 'P', or 'N' or 'Q'. The input could
be in upper or lower case.
P: Only 10 lines of information about the
used procedures are displayed at one
time in the window as shown in Figure 13.
This option would display the previous
10 lines of information, if any.
N: Only 10 lines of information about the
used procedures are displayed at one
time in the window as shown in Figure 13.
This option would display the next 10
lines of information, if any. Hitting
enter key without any input is same as
entering 'N'.
Q: This option would bring up the window
as shown in Figure 12.
________________________________________________________________________________
| SQR Cross Reference Information |
| Included Files, Tables & Declared Procedures & Path to SQR |
| Search String: ALL |
| Customer: My Comapny Name |
| Include File Name Folder |
| |
| 1. XFSINCL.SQC C:\DEMO\PROD\SQC |
| 2. acme.sqc C:\DEMO\PROD\SQC |
| 3. beginjob.sqc C:\DEMO\PROD\SQC |
| 4. brkname.sqc C:\DEMO\PROD\SQC |
| 5. calcdate.sqc C:\DEMO\PROD\SQC |
| 6. crldtbl.sqc C:\DEMO\PROD\SQC |
| 7. crtbl.sqc C:\DEMO\PROD\SQC |
| 8. curdate.sqc C:\DEMO\PROD\SQC |
| 9. dbname.sqc C:\DEMO\PROD\SQC |
| 10. dispname.sqc C:\DEMO\PROD\SQC |
| |
| Q=Quit, P=Prev, N=Next, S=Search |
| Select Number (For Tables, Declared Procedures & Path to SQR Information) OR |
| Select Number + T (For Tables Information, Example : 1T) OR |
| Select Number + P (For Declared Procedures Information, Example : 1P) OR |
| Select Number + S (For Path to SQR Information, Example : 1S) |
| |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 14
At this point the appropriate available options for the users are a
valid number of the Include file to be selected, or a valid number of the Include
file to be selected + T, or valid number of the Include file to be selected + P, or
a valid number of the Include file to be selected + S, or 'P', or 'N', or 'S' or 'Q'.
The input could be in upper or lower case.
Valid Number of the Include (Example 5) A window as shown in
file to selected: Figure 15 will be presented to the
user which will enable the user to
view tables, procedure and path to SQR
information of the selected Include
file.
Valid Number of the Inlcude (Example 5T) A window as shown in
file to selected + T: Figure 16 will be presented to the
user which will enable the user to
view tables information of the
selected Include file.
Valid Number of the Inlcude (Example 5P) A window as shown in
file to selected + P: Figure 17 will be presented to the
user which will enable the user to
view procedure information of the
selected Include file.
Valid Number of the Inlcude (Example 5S) A window as shown in
file to selected + S: Figure 18 will be presented to the
user which will enable the user to
view Path to SQR information of the
selected Include file.
P: Only 10 Include file names are displayed
in the window as shown in Figure 14.
This option would display the previous
10 Include file Names, if any.
N: Only 10 Include file names are displayed
in the window as shown in Figure 14.
This option would display the next
10 Include file Names, if any.
S: Include file Names are displayed in
alphabitical ascending order as shown in
Figure 14. This option would help the
user to view the Include file names from
a selected string.
Q: This option would bring up the window
as shown in Figure 6.
________________________________________________________________________________
| SQR Cross Reference Information |
|Used Tables, Declared Procedures & Path to SQR for Included file XFSINCL.SQC |
| Search String: ALL |
| Customer: My Comapny Name |
| |
| 1. Table: [$WHICHTABLE] XFSTA R |
| 2. Proc: XFSC-BEGIN-TABLE-TRAN |
| 3. Proc: XFSC-COMMIT-TABLE-TRAN |
| 4. Proc: XFSC-GET-INSTANCE($WHICHTABLE,$WHICHSQR,:WHICHINSTANCE) |
| 5. Proc: XFSC-INSERT-SQL-ERROR($XFSCSQLERRORMSG) |
| 6. Proc: XFSC-UPDATE-SQL-ERROR($XFSCSQLERRORMSG) |
| 7. Proc: XFSC-CONVERT-TO-DEFAULTDATE($INFORMAT, $SYSDATE, :$NEWDATE) |
| 8. Proc: XFSC-CONVERT-TO-DEFAULTTIME($SYSTIME, :$NEWTIME) |
| 9. Proc: XFSC-GET-CURR-DATETIME(:$OUTDATE,:$OUTTIME,:$OUTDATETIME,:$SH..|
| 10. Proc: XFSC-SQR-EXECUTION($WHICHTABLE,:#WHICHINSTANCE,$WHERE,$WHICHS..|
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 15
At this point the appropriate available options for the users are a
valid number of the SQR to be selected, or 'P', or 'N' or 'Q'. The input could
be in upper or lower case.
P: Only 10 lines of information about the
Used Tables, Declared Procedures & Path
to SQR for Included file are displayed
at one time in the window as shown in
Figure 15. This option would display
the previous 10 lines of information,
if any.
N: Only 10 lines of information about the
Used Tables, Declared Procedures & Path
to SQR for Included file are displayed
at one time in the window as shown in
Figure 15. This option would display
the next 10 lines of information,
if any.
Q: This option would bring up the window
as shown in Figure 14.
________________________________________________________________________________
| SQR Cross Reference Information |
| Used Tables SQR in Included file XFSINCL.SQC |
| |
| Customer: My Comapny Name |
| |
| 1. Table: [$WHICHTABLE] XFSTA R |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 16
At this point the appropriate available options for the users are a
valid number of the SQR to be selected, or 'P', or 'N' or 'Q'. The input could
be in upper or lower case.
P: Only 10 lines of information about the
Used Tables in the Included file are
displayed at one time in the window as
shown in Figure 16. This option would
display the previous 10 lines of informa-
tion, if any.
N: Only 10 lines of information about the
Used Tables in the Included file are
displayed at one time in the window as
shown in Figure 16. This option would
display the next 10 lines of information,
if any.
Q: This option would bring up the window
as shown in Figure 14.
________________________________________________________________________________
| SQR Cross Reference Information |
| Declared Procedures in Included file XFSINCL.SQC |
| |
| Customer: My Comapny Name |
| |
| 1. Proc: XFSC-BEGIN-TABLE-TRAN |
| 2. Proc: XFSC-COMMIT-TABLE-TRAN |
| 3. Proc: XFSC-GET-INSTANCE($WHICHTABLE,$WHICHSQR,:WHICHINSTANCE) |
| 4. Proc: XFSC-INSERT-SQL-ERROR($XFSCSQLERRORMSG) |
| 5. Proc: XFSC-UPDATE-SQL-ERROR($XFSCSQLERRORMSG) |
| 6. Proc: XFSC-CONVERT-TO-DEFAULTDATE($INFORMAT, $SYSDATE, :$NEWDATE) |
| 7. Proc: XFSC-CONVERT-TO-DEFAULTTIME($SYSTIME, :$NEWTIME) |
| 8. Proc: XFSC-GET-CURR-DATETIME(:$OUTDATE,:$OUTTIME,:$OUTDATETIME,:$SH..|
| 9. Proc: XFSC-SQR-EXECUTION($WHICHTABLE,:#WHICHINSTANCE,$WHERE,$WHICHS..|
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 17
At this point the appropriate available options for the users are a
valid number of the SQR to be selected, or 'P', or 'N' or 'Q'. The input could
be in upper or lower case.
P: Only 10 lines of information about the
Declared Procedures in the Included file
are displayed at one time in the window
as shown in Figure 17. This option
would display the previous 10 lines of
information, if any.
N: Only 10 lines of information about the
Declared Procedures in the Included file
are displayed at one time in the window
as shown in Figure 17. This option
would display the next 10 lines of
information, if any.
Q: This option would bring up the window
as shown in Figure 14.
________________________________________________________________________________
| SQR Cross Reference Information |
| Path to SQR for Included file XFSINCL.SQC |
| |
| Customer: My Comapny Name |
| |
| 1. EX10A.SQR C:\DEMO\PROD\SQR\ |
| 2. EX11A.SQR C:\DEMO\PROD\SQR\ |
| 3. EX12A.SQR C:\DEMO\PROD\SQR\ |
| 4. EX12B.SQR C:\DEMO\PROD\SQR\ |
| 5. EX12C.SQR C:\DEMO\PROD\SQR\ |
| 6. EX13A.SQR C:\DEMO\PROD\SQR\ |
| 7. EX14A.SQR C:\DEMO\PROD\SQR\ |
| 8. EX16A.SQR C:\DEMO\PROD\SQR\ |
| 9. EX16B.SQR C:\DEMO\PROD\SQR\ |
| 10. EX16C.SQR C:\DEMO\PROD\SQR\ |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 18
At this point the appropriate available options for the users are a
valid number of the SQR to be selected, or 'P', or 'N' or 'Q'. The input could
be in upper or lower case.
P: Only 10 lines of information about the
Path to SQR for the Included file are
displayed at one time in the window
as shown in Figure 18. This option
would display the previous 10 lines of
information, if any.
N: Only 10 lines of information about the
Path to SQR for the Included file are
displayed at one time in the window
as shown in Figure 18. This option
would display the next 10 lines of
information, if any.
Q: This option would bring up the window
as shown in Figure 14.
________________________________________________________________________________
| SQR Cross Reference Information |
| Declared Procedures, Parameters, Where Declared & Path to SQR |
| Search String: ALL |
| Customer: My Comapny Name |
| Procedure Name |
| |
| 1. XFSC-BEGIN-TABLE-TRAN |
| 2. XFSC-COMMIT-TABLE-TRAN |
| 3. XFSC-GET-INSTANCE($WHICHTABLE,$WHICHSQR,:WHICHINSTANCE) |
| 4. XFSC-INSERT-SQL-ERROR($XFSCSQLERRORMSG) |
| 5. XFSC-UPDATE-SQL-ERROR($XFSCSQLERRORMSG) |
| 6. XFSC-CONVERT-TO-DEFAULTDATE($INFORMAT, $SYSDATE, :$NEWDATE) |
| 7. XFSC-CONVERT-TO-DEFAULTTIME($SYSTIME, :$NEWTIME) |
| 8. XFSC-GET-CURR-DATETIME(:$OUTDATE,:$OUTTIME,:$OUTDATETIME,:$SHORTOUTD..|
| 9. XFSC-SQR-EXECUTION($WHICHTABLE,:#WHICHINSTANCE,$WHERE,$WHICHSQR) |
| 10. XFSC-SQR-UPDATE |
| |
| Q=Quit, P=Prev, N=Next, S=Search |
| Select Number to see Where Declared & Path to SQR |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 19
At this point the appropriate available options for the users are a
valid number of the Declared Procedure to be selected, or 'P', or 'N', or 'S' or 'Q'.
The input could be in upper or lower case.
Valid Number of the Declared (Example 5) A window as shown in
Procedure to be selected: Figure 20 will be presented to the
user which will enable the user to
view where the selected procedure
is declared and path to SQR
information.
P: Only 10 Procedure names are displayed
in the window as shown in Figure 19.
This option would display the previous
10 Procedure Names, if any.
N: Only 10 Procedure names are displayed
in the window as shown in Figure 19.
This option would display the next
10 Procedure Names, if any.
S: Procedure Names are displayed in
alphabitical ascending order as shown in
Figure 19. This option would help the
user to view the Procedure Names from
a selected string.
Q: This option would bring up the window
as shown in Figure 6.
________________________________________________________________________________
| SQR Cross Reference Information |
| Where Procedure XFSC-BEGIN-TABLE-TRAN Declared |
| |
| Customer: My Comapny Name |
| File Name Folder |
| |
| 1. XFSINCL.SQC C:\DEMO\PROD\SQC |
| 2. EX10A.SQR C:\DEMO\PROD\SQR\ |
| 3. EX11A.SQR C:\DEMO\PROD\SQR\ |
| 4. EX12A.SQR C:\DEMO\PROD\SQR\ |
| 5. EX12B.SQR C:\DEMO\PROD\SQR\ |
| 6. EX12C.SQR C:\DEMO\PROD\SQR\ |
| 7. EX13A.SQR C:\DEMO\PROD\SQR\ |
| 8. EX14A.SQR C:\DEMO\PROD\SQR\ |
| 9. EX16A.SQR C:\DEMO\PROD\SQR\ |
| 10. EX16B.SQR C:\DEMO\PROD\SQR\ |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 20
At this point the appropriate available options for the users are 'P', or
'N', or 'Q'. The input could be in upper or lower case.
P: Only 10 lines of information. about where
a selected procedure being used, are
displayed in the window as shown in
Figure 20. This option would display
the previous 10 lines of information,
if any.
N: Only 10 lines of information. about where
a selected procedure being used, are
displayed in the window as shown in
Figure 20. This option would display
the next 10 lines of information,
if any.
Q: This option would bring up the window
as shown in Figure 19.
________________________________________________________________________________
| SQR Cross Reference Information |
| Tables, Access Mode, Where Used & Path to SQR |
| Search String: ALL |
| Customer: My Comapny Name |
| Table Name Mode |
| |
| 1 APPTS I |
| 2 CASH_RECEIPTS I R |
| 3 CUSTOMERS I R | 4 CUSTOMERS_EXT D I |
| 5 DEPT I |
| 6 EMP I |
| 7 ORDERS I R |
| 8 ORDLINES I R |
| 9 PRODCUTS I R |
| 10 REMINDERS I R |
| Q=Quit, P=Prev, N=Next, S=Search |
| Select Number (For all Modes) OR |
| Select Number + Mode (For a selected Mode) OR |
| To see Where Table Used & Path to SQR |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 21
At this point the appropriate available options for the users are a
valid number of the Table to be selected or a valid number of the Table to be selected
+ a valid table access mode (Example 'R', 'I', 'U', 'D'), or 'P', or 'N', or 'S' or 'Q'.
The input could be in upper or lower case.
Valid Number of the Table (Example 5) A window as shown in
to be selected: Figure 22 will be presented to the
user which will enable the user to
view where the selected table in any
mode is used and path to SQR
information.
Valid Number of the Table (Example 5R or 5I or 5U or 5D etc)
to be selected + Mode: A window as shown in Figure 23 will be
presented to the user which will enable
the user to view where the selected table
in the selected mode is used and path to
SQR information.
P: Only 10 Table names in ascending order
are displayed in the window as shown in
Figure 21. This option would display
the previous 10 Table names, if any.
N: Only 10 Table names in ascending order
are displayed in the window as shown in
Figure 21. This option would display
the next 10 Table names, if any.
S: Table Names are displayed in
alphabitical ascending order as shown in
Figure 21. This option would help the
user to view the Table Names from
a selected string.
Q: This option would bring up the window
as shown in Figure 6.
________________________________________________________________________________
| SQR Cross Reference Information |
| Where Table ORDERS Used & Path to SQR |
| Mode: I R |
| Customer: My Comapny Name |
| File Name Folder |
| |
| 1 EX13A.SQR C:\DEMO\PROD\SQR\ |
| 2 EX17A.SQR C:\DEMO\PROD\SQR\ |
| 3 EX7A.SQR C:\DEMO\PROD\SQR\ |
| 4 EX8A.SQR C:\DEMO\PROD\SQR\ |
| 5 EX8B.SQR C:\DEMO\PROD\SQR\ |
| 6 EX8C.SQR C:\DEMO\PROD\SQR\ |
| 7 VERINST.SQR C:\DEMO\PROD\SQR\ |
| 8 LDTBL.SQC C:\DEMO\PROD\SQC\ |
| 9 CRTBL.SQC C:\DEMO\PROD\SQC\ |
| 10 LDTBLS.SQR C:\DEMO\PROD\SQR\ |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 22
At this point the appropriate available options for the users are 'P', or
'N', or 'Q'. The input could be in upper or lower case.
P: Only 10 lines of information about the
selected table in any mode are displayed
in the window as shown in Figure 22.
This option would display the previous
10 lines of information, if any.
N: Only 10 lines of information about the
selected table in any mode are displayed
in the window as shown in Figure 22.
This option would display the next 10
lines of information, if any.
Q: This option would bring up the window
as shown in Figure 21.
________________________________________________________________________________
| SQR Cross Reference Information |
| Where Table ORDERS Used & Path to SQR |
| Mode: R |
| Customer: My Comapny Name |
| File Name Folder |
| |
| 1 EX13A.SQR C:\DEMO\PROD\SQR\ |
| 2 EX17A.SQR C:\DEMO\PROD\SQR\ |
| 3 EX7A.SQR C:\DEMO\PROD\SQR\ |
| 4 EX8A.SQR C:\DEMO\PROD\SQR\ |
| 5 EX8B.SQR C:\DEMO\PROD\SQR\ |
| 6 EX8C.SQR C:\DEMO\PROD\SQR\ |
| 7 VERINST.SQR C:\DEMO\PROD\SQR\ |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|______________________________________________________________________________|
FIGURE 23
At this point the appropriate available options for the users are 'P', or
'N', or 'Q'. The input could be in upper or lower case.
P: Only 10 lines of information about the
selected table in the selected mode are
displayed in the window as shown in
Figure 23. This option would display
the previous 10 lines of information,
if any.
N: Only 10 lines of information about the
selected table in the selected mode are
displayed in the window as shown in
Figure 23. This option would display
the next 10 lines of information, if any.
Q: This option would bring up the window
as shown in Figure 21.
____________________________________________________________________________
| SQR Cross Reference Information |
| Execution Information by SQR |
| Search String: ALL |
| Customer: My Comapny Name |
| SQR Name Anal Add Date & Time Added Folder |
| Code |
| |
| 1. EX10A.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 2. EX11A.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 3. EX12A.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 4. EX12B.SQR Y Y 1998-02-11 18:17:00 C:\DEMO\PROD\SQR\ |
| 5. EX12C.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 6. EX13A.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 7. EX14A.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 8. EX16A.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 9. EX16B.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| 10. EX16C.SQR Y Y 1998-02-11 18:26:00 C:\DEMO\PROD\SQR\ |
| |
| Q=Quit, P=Prev, N=Next, S=Search |
| Select SQR File By Number for Execution Information |
| Please Enter your chice: |
|__________________________________________________________________________|
FIGURE 24
At this point the appropriate available options for the users are a
valid number of the SQR to be selected or 'P', or 'N', or 'S' or 'Q'. The input
could be in upper or lower case.
Valid Number of the SQR (Example 5) A window as shown in
to be selected: Figure 25 will be presented to the
user which will enable the user to
view the Execution information of
the selected SQR. If the selected
SQR does not have required code to
store the Execution Information then
the message "Code is not added to Track
Executions" will be displayed and after
user's input window as shown in Figure 25
will be refreshed.
P: Only 10 SQR file names in ascending order
are displayed in the window as shown in
Figure 24. This option would display
the previous 10 SQR file names, if any.
N: Only 10 SQR file names in ascending order
are displayed in the window as shown in
Figure 24. This option would display
the next 10 SQR file names, if any.
S: SQR file Names are displayed in
alphabitical ascending order as shown in
Figure 24. This option would help the
user to view the SQR file Names from
a selected string.
Q: This option would bring up the window
as shown in Figure 6.
____________________________________________________________________________
| SQR Cross Reference Information |
| Execution Information for LDTBLS.SQR |
| |
| Customer: My Comapny Name |
| Start Date & Time Elapsed Comp Username Platform |
| Time Code Name |
| |
| 1 1998-02-15 08:04:00 01:00 C WINDOWS-NT |
| 2 1998-02-16 08:08:00 01:00 C WINDOWS-NT |
| 3 1998-02-17 08:02:00 01:00 C WINDOWS-NT |
| 4 1998-02-18 07:56:00 00:00 C WINDOWS-NT |
| 5 1998-02-19 08:04:00 00:00 I WINDOWS-NT |
| 6 1998-02-19 08:07:00 01:00 C WINDOWS-NT |
| 7 1998-02-20 08:03:00 01:00 C WINDOWS-NT |
| 8 1998-02-21 08:06:00 02:00 C WINDOWS-NT |
| 9 1998-02-22 08:02:00 01:00 C WINDOWS-NT |
| 10 1998-02-23 08:00:00 01:00 C WINDOWS-NT |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|__________________________________________________________________________|
FIGURE 25
At this point the appropriate available options for the users are 'P', or
'N' or 'Q'. The input could be in upper or lower case.
P: Only 10 lines of execution information
for the selected SQR in ascending order
are displayed in the window as shown in
Figure 25. This option would display
the previous 10 lines of information,
if any.
N: Only 10 lines of execution information
for the selected SQR in ascending order
are displayed in the window as shown in
Figure 25. This option would display
the next 10 lines of information,
if any.
Q: This option would bring up the window
as shown in Figure 24.
____________________________________________________________________________
| SQR Cross Reference Information |
| Execution Information By Start Date & Time |
| Search String: ALL |
| Customer: My Comapny Name |
| SQR Name Start Date & Time Elapsed Comp Username |
| Time Code |
| |
| 1 EX10A.SQR 1998-02-15 08:04:00 01:00 C |
| 2 EX11A.SQR 1998-02-15 08:06:00 00:00 C |
| 3 EX12A.SQR 1998-02-15 08:07:00 07:00 C |
| 4 EX12B.SQR 1998-02-15 08:15:00 03:00 C |
| 5 EX12C.SQR 1998-02-15 08:20:00 01:00 I |
| 6 EX12C.SQR 1998-02-15 08:26:00 05:00 C |
| 7 EX13A.SQR 1998-02-15 08:32:00 02:00 C |
| 8 EX14A.SQR 1998-02-15 08:34:00 09:00 C |
| 9 EX16A.SQR 1998-02-15 08:47:00 04:00 C |
| 10 EX16B.SQR 1998-02-15 08:55:00 01:00 C |
| |
| Q=Quit, P=Prev, N=Next |
| Please Enter your chice: |
|__________________________________________________________________________|
FIGURE 26
At this point the appropriate available options for the users are 'P', or
'N', or 'S' or 'Q'. The input could be in upper or lower case.
P: Only 10 lines of execution information
by Start Date & Time in ascending order
are displayed in the window as shown in
Figure 26. This option would display
the previous 10 lines of information,
if any.
N: Only 10 lines of execution information
by Start Date & Time in ascending order
are displayed in the window as shown in
Figure 26. This option would display
the next 10 lines of information,
if any.
S: Execution information are displayed in
ascending order by Start Date & Time
as shown in Figure 26. This option
would help the user to view the execution
information from a selected Start Date &
Time.
Q: This option would bring up the window
as shown in Figure 6.