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

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.

proc.png 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.


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x