PBSYC.SQL script – PB Docs 126

PBSYC.SQL script

What it does

The PBSYC.SQL script contains SQL code that overwrites stored procedures that
correspond to the same version of PowerBuilder in the Adaptive Server sybsystemprocs
database and then re-creates them.

The PBSYC.SQL script uses the sybsystemprocs database
to hold the PowerBuilder stored procedures. This database is created
when you install Adaptive Server.

When to run it

Before you connect to an Adaptive Server database in PowerBuilder for
the first time
using the ASE or SYC DBMS identifier,
you or your database administrator must run the PBSYC.SQL script
once per database server into the sybsystemprocs database.

Run PBSYC.SQL if the server at your site
will be accessed by anyone using the PowerBuilder or by deployment

If you or your database administrator have already run the
current version of PBSYC.SQL to install PowerBuilder stored
procedures in the sybsystemprocs database on
your server, you need not rerun the script to install the stored procedures

For instructions on running PBSYC.SQL,
see “How to run the scripts”.

Stored procedures it creates

The PBSYC.SQL script creates the following PowerBuilder stored
procedures in the Adaptive Server sybsystemprocs database.
The procedures are listed in the order in which the script creates

PBSYC.SQL stored procedure

What it does


Lists the columns in a table.


Determines whether a table has a primary


Lists the tables that reference the current


Retrieves a description of the argument
list for a specified stored procedure.


Lists available stored procedures and
extended stored procedures.

If the SystemProcs DBParm parameter is set to 1 or Yes (the default), sp_pb126proclist displays
both system stored procedures and user-defined stored procedures.
If SystemProcs is set to 0 or No, sp_pb126proclist displays
only user-defined stored procedures.


Retrieves the text of a stored procedure
from the SYSCOMMENTS table.


Retrieves information about all tables
in a database, including those for which the current user has no

PBSYC.SQL contains
the default version of sp_pb126table.
If you want to replace the default version of sp_pb126table with a
version that restricts the table list to those tables for which
the user has SELECT permission, you can run the PBSYC2.SQL script,
described in “PBSYC2.SQL script”.


Retrieves information about all indexes
for a specified table.

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