Using ISQL to run the stored procedure scripts – PB Docs 126

To use ISQL to
run the PowerBuilder stored procedure scripts:

1. Connect to the sybsystemprocs Adaptive
   Server database as the system administrator.

2. Open one of the following files containing the PowerBuilder stored procedure
   script you want to run:

   • PBSYC.SQL

   • PBSYC2.SQL

3. 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:

   PowerBuilder

   <span>isql /U sa /S</span> <span>SERVERNAME</span> <span>/i</span> <span>pathname</span> <span>/P</span> {<span> password</span> }

   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):

   PowerBuilder

   isql /U sa /S TESTDB /i d:serverpbsyb.sql /P&#160;<br>isql /U sa /S SALES /i d:serverpbsyc.sql /P adminpwd

   1	isql /U sa /S TESTDB /i d:serverpbsyb.sql /P&#160;<br>isql /U sa /S SALES /i d:serverpbsyc.sql /P adminpwd