Creating the extended attribute system tables
When you create or modify a table in PowerBuilder, the information
you provide is stored in five system tables in your database. These
system tables contain extended attribute information such as the text to
use for labels and column headings, validation rules, display formats,
and edit styles. (These system tables are different from the system
tables provided by your DB2 database.)
By default, the extended attribute system tables are created
automatically the first time a user connects to the database using
PowerBuilder.
When you use the DirectConnect interface
When you use the DirectConnect interface, the extended attribute
system tables are not created automatically. You must run the
DB2SYSPB.SQL script to create the system tables as described in Using the DB2SYSPB.SQL
script.
To ensure that the extended attribute system tables are created
with the proper access rights:
-
Make sure the first person to connect to the database with
PowerBuilder has sufficient authority to create tables and grant
permissions to PUBLIC.This means that the first person to connect to the database
should log in as the database owner, database administrator, system
user, system administrator, or system owner, as specified by your
DBMS.