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 main problem with SQR is that full source file cannot be viewed by the user
when include files are used. Also SQR cannot generate a compiler listing, similar to the
one generated by traditional program development tools like COBOL, FORTRAN, C, C++, BASIC
etc. So the SQR Expander Software Objectives are to create a single
expanded file by
expanding the included files and to generate a
compiler like listing with the following
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 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. XFSES (sub directory)
Files under XFSES sub directory:
A. EXS*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. READMEES.TXT which gives instructions to run
SQR Expander Program.
D. XFSES.DAT which has default parameters to run
SQR Expander Program.
The values in this file may have to be
changed to your needs.
E. XFSQR.LST which has the names of SQRs that have to
be expanded. 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 Expander (EXS*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
Expander reads the SQR Expander Initialization file once, at the beginning
of the program. The name of this initialization file is 'XFSES.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 Expander Initialization's Folder Name; Q=Quit: |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|__________________________________________________________________|
FIGURE 1
The initialization file contains vital information required by the
SQR Expander program and should be updated before running the SQR Expander
program. The SQR Expander program reads the following information from
the initialization file:
1. INPUTFOLDER: The names of the SQRs that are to be expanded and
be listed 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.
2. 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 SQR Expander would look first in the first SQRFOLDER,
then the next SQRFOLDER and so on.
3. 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 SQR
Expander would look first in the first INCLFOLDER, then
the next INCLFOLDER and so on.
4. 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'.
5. 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'.
Following is contents of a sample SQR Expander initialization file:
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\XFSES\'
XFEFOLDER = 'C:\INS\XFE\'
XFLFOLDER = 'C:\INS\XFL\'
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\XFSES\':
SQR011.SQR
LDTBLS.SQR
SQR085.SQR
SQR006.SQR
When the SQR Expander 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.
____________________________________________________________________
|Customer: My Comapny Name |
|Program: c:\ins\xfses\exso010.sqt |
|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\XFSES\ |
|Expand File Folder (XFEFOLDER): C:\INS\XFE\ |
|List File Folder (XFLFOLDER): C:\INS\XFL\ |
|E=Expand; Q=Quit: |
| |
| |
| |
| |
| |
| |
| |
|__________________________________________________________________|
FIGURE 2
At this point the appropriate available options for the users are 'E' , or
'Q'. The input could be in upper or lower case. If the user's option is 'E'
then an expanded file and a list file for each SQR that were listed in 'XFSQR.LST'
in the Input Folder would be created. If the user's option is 'Q' then the window
would be closed and the execution of SQR Expander would be stopped.
For the above example the main SQR files and the included files used in each
SQR file are pulled from the following folders in the order they are listed:
'C:\SQR\PAYROLL\SOURCE\TEST\'
'C:\SQR\PAYROLL\SOURCE\STAGE\'
'C:\SQR\PAYROLL\SOURCE\PROD\'
'C:\INCLUDE\PAYROLL\SOURCE\TEST\'
'C:\INCLUDE\PAYROLL\SOURCE\STAGE\'
'C:\INCLUDE\PAYROLL\SOURCE\PROD\'
If the required file exist in a folder then the next folder in the list would
not be searched, otherwise the search would continue.
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\'.
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.
This compiler listing consists of the following information:
1. Listing of all the files used in the SQR with line numbers in the expanded
file and line numbers in the individual file.
2. Names of the files used in the SQR and their Folder's name and the
included files that are not needed are highlighted.
3. Tree Structure of Procedures Used in the SQR
4. Procedures Declared in the SQR
5. Tables used in the SQR and the mode in which they were used
6. Variable Listing used in the SQR
7. Warning Error Messages