PBSYC2.SQL script – PB Docs 2021

What it does

The PBSYC2.SQL script contains SQL code that drops and
re-creates one PowerBuilder stored procedure in the Adaptive Server
sybsystemprocs database: a replacement version of
sp_pb190table.

The default version of sp_pb190table is installed by the
PBSYC.SQL script. PowerBuilder uses the sp_pb190table procedure to
build a list of all tables in the database, including those for which
the current user has no permissions. This list displays in the Select
Tables dialog box in PowerBuilder.

For security reasons, you or your database administrator might
want to restrict the table list to display only those tables for which
a user has permissions. To do this, you can run the PBSYC2.SQL script
after you run PBSYC.SQL. PBSYC2.SQL replaces the default version of
sp_pb190table with a new version that displays a restricted table list
including only tables and views:

When to run it

If you are accessing an Adaptive Server database using the ASE
or SYC DBMS identifier in PowerBuilder, you must first run
PBSYC.SQL once per database server to install the required
PowerBuilder stored procedures in the sybsystemprocs database.

After you run PBSYC.SQL, you can optionally run PBSYC2.SQL if
you want to replace sp_pb190table with a version that restricts the
table list to those tables for which the user has SELECT
permission.

If you do not want to restrict the table list, there is no need
to run PBSYC2.SQL.

For instructions on running PBSYC2.SQL, see How to run the
scripts.

Stored procedure it
creates

The PBSYC2.SQL script creates the following PowerBuilder stored
procedure in the Adaptive Server sybsystemprocs database: