Using SQL Advantage to run the stored procedure scripts

SQL Advantage is an interactive SQL utility that comes with the Open Client software on the Windows platform. If you have SQL Advantage installed, use the following procedure to run the PowerBuilder stored procedure scripts.

For complete instructions on using SQL Advantage, see your Open Client documentation.

1. Start the SQL Advantage utility.

2. Open a connection to the sybsystemprocs Adaptive Server database as the system administrator.

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

   • PBSYC.SQL

   • PBSYC2.SQL

4. Delete the use sybsystemprocs command and the go command at the beginning of each script.

   SQL Advantage requires that you issue the use sybsystemprocs command by itself, with no other SQL commands following it. When you open a connection to the sybsystemprocs database in step 2, you are in effect issuing the use sybsystemprocs command. This command should not be issued again as part of the stored procedure script.

   Therefore, to successfully install the stored procedures, you must delete the lines shown in the following table from the beginning of the PowerBuilder stored procedure script before executing the script.

   Before executing this script	Delete these lines
   PBSYC.SQL	use sybsystemprocs go
   PBSYC2.SQL	use sybsystemprocs go

5. Execute all of the statements in the SQL script.

6. Exit the SQL Advantage session.