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.
As it has already been explained under SQR Expander, it is easier and faster to debug
a single expanded SQR rather than an SQR that has included files. After debugging, the
modifications made into the expanded SQR have to be entered into the respective SQR or
into the included files. This is a time consuming and error prone process. So the
objective of SQR Shrink is to automate this process. SQR Shrink does this job, by
writing automatically the modifications into the respective
SQR or into the included files.
To install the SQR Shrink the following 3 Install files are needed:
1. README.TXT
2. INSTXREF.EXE
3. INSSQRXF.SQT
Following are the steps to install the SQR Shrink:
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. SHS*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 Shrink Program.
D. XFSES.DAT which has default parameters to run
SQR Shrink Program.
The values in this file may have to be
changed to suit your needs.
E. XFSQR.LST which has the names of SQRs that have to
be shrunk. 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
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 Shrink (SHS*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
Shrink reads the SQR Shrink 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 Shrink Initialization's Folder Name; Q=Quit: |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|__________________________________________________________________|
FIGURE 1
The initialization file contains vital information required by the
SQR Shrink program and should be updated before running the SQR Shrink
program. The SQR Shrink program reads the following information from
the initialization file:
1. INPUTFOLDER: The names of the SQRs that are to be shrunk
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. XFEFOLDER: This is the name of the folder from which the expanded SQR
files will be pulled from. The appropriate SQR and Include
files used within the expanded SQR file will be updated or
recreated as needed.
3. TEMPFOLDER: This is the name of the folder where any needed temporary file
for the SQR Shrink will be saved.
Following is needed contents of a sample SQR Shrink initialization file:
INPUTFOLDER = 'C:\INS\XFSES\'
XFEFOLDER = 'C:\INS\XFE\'
TEMPFOLDER = 'C:\INS\TEMP\'
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 XFEFOLDER 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 Shrink 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 Company Name |
|Program: c:\ins\xfses\shso010.sqt |
|Parametes used: |
|Input File Folder (INPUTFOLDER): C:\INS\XFSES\ |
|Expand File Folder (XFEFOLDER): C:\INS\XFE\ |
|Temporary File Folder (TEMPFOLDER): C:\INS\TEMP\ |
|E=Shrink; Q=Quit: |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
|__________________________________________________________________|
FIGURE 2
At this point the appropriate available options for the users are 'S' or
'Q'. The input could be in upper or lower case. If the user's option is 'S'
then the required SQR and Include files would be updated or recreated for each SQR
that were listed in 'XFSQR.LST' in the Input Folder. If the user's option is 'Q'
then the window would be closed and the execution of SQR Shrink would be stopped.
For the above example the expanded files SQR011.XFE, LDTBLS.XFE, SQR085.XFE and
SQR006.XFE would be pulled from C:\INS\XFE\ and the required SQR and include files
woule be updated or created.
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.