Using SQL Advantage to run the stored procedure scripts – PB Docs 150

To use SQL Advantage
to run the PowerBuilder stored procedure scripts:

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.