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

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 rom 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.