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 machines.
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 again.
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
them.
|
PBSYC.SQL stored procedure |
What it does |
|---|---|
|
sp_pb190column |
Lists the columns in a table. |
|
sp_pb190pkcheck |
Determines whether a table has a primary |
|
sp_pb190fktable |
Lists the tables that reference the current |
|
sp_pb190procdesc |
Retrieves a description of the argument list for |
|
sp_pb190proclist |
Lists available stored procedures and extended If the SystemProcs DBParm |
|
sp_pb190text |
Retrieves the text of a stored procedure from the |
|
sp_pb190table |
Retrieves information about all tables in a PBSYC.SQL contains the default |
|
sp_pb190index |
Retrieves information about all indexes for a |