Specifications

Working with tables
96 InfoMaker
In the Employee table, for example, one column name is Emp_lname. A label
and a heading for the column are defined for InfoMaker to use in reports. The
column label is defined as
Last Name:. The column heading is defined as
Last Name. The label and heading are stored in the PBCatCol table in the
extended attribute system tables.
The extended attribute system tables are maintained by InfoMaker and only
InfoMaker users can enter information into them. Table 3-6 lists the extended
attribute system tables. For more information, see Appendix B, “The Extended
Attribute System Tables.”
Table 3-6: Extended attribute system tables
Opening and
displaying system
tables
You can open system tables like other tables in the Database painter.
By default, InfoMaker shows only user-created tables in the Objects view. If
you highlight Tables and select Show System Tables from the pop-up menu,
InfoMaker also displays system tables.
Creating and editing temporary tables
You can create and edit temporary tables in the Database painter, SQL Select
painter, or Report painter when you use the ASE or SYC native driver to
connect to an Adaptive Server database, or the SNC native driver to connect to
a Microsoft SQL Server 2005 database. Temporary tables persist for the
duration of a database connection, residing in a special database called
“
tempdb”.
Creating temporary
tables
You add a temporary table to the tempdb database by right-clicking the
Temporary Tables icon in the Objects view and selecting New. The table is
designated as a temporary table by assigning a name that starts with the #
character. When you save the table, the Create New Temporary Table dialog
box displays. The # character is added automatically.
If there is no Temporary Tables icon in the Objects view, right-click the Tables
icon and select New. Assign a table name prefaced with the # character.
This system table Stores this extended attribute information
PBCatCol Column data such as name, header and label for reports and
forms, and header and label positions
PBCatEdt Edit style names and definitions
PBCatFmt Display format names and definitions
PBCatTbl Table data such as name, fonts, and comments
PBCatVld Validation rule names and definitions