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
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_pb126column

Lists the columns in a table.

sp_pb126pkcheck

Determines whether a table has a primary
key.

sp_pb126fktable

Lists the tables that reference the current
table.

sp_pb126procdesc

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

sp_pb126proclist

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.

sp_pb126text

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

sp_pb126table

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

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

sp_pb126index

Retrieves information about all indexes
for a specified table.


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