Using ISQL to run the stored procedure scripts
ISQL is an interactive SQL utility that comes with the Open
Client software on the Windows platforms. If you have ISQL installed, use the following procedure
to run the PowerBuilder stored procedure scripts.
For complete instructions on using ISQL, see your Open Client documentation.
To use ISQL to
run the PowerBuilder stored procedure scripts:
-
Connect to the sybsystemprocs Adaptive
Server database as the system administrator. -
Open one of the following files containing the PowerBuilder stored procedure
script you want to run:-
PBSYC.SQL
-
PBSYC2.SQL
-
-
Issue the appropriate ISQL command
to run the SQL script with the
user ID, server name, and (optionally) password you specify. Make
sure you specify uppercase and lowercase exactly as shown:1<span>isql /U sa /S</span> <span>SERVERNAME</span> <span>/i</span> <span>pathname</span> <span>/P</span> {<span> password</span> }Parameter
Description
sa
The user ID for the system administrator.
Do not change this user ID.SERVERNAME
The name of the computer running the
Adaptive Server database.pathname
The drive and directory containing the SQL script you want to run.
password
(Optional) The password for the sa (system administrator)
user ID. The default Adaptive Server installation creates the sa user
ID without a password. If you changed the password for sa during
the installation, replace password with your
new password.For example, if you are using PowerBuilder and are accessing
the stored procedure scripts from the product CD-ROM, type either
of the following (assuming D is your CD-ROM drive):1isql /U sa /S TESTDB /i d:serverpbsyb.sql /P <br>isql /U sa /S SALES /i d:serverpbsyc.sql /P adminpwd