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.
