Go to Glossary Search VisualAge C++ Help Go to VisualAge C++ Help Home Page Go to WWW VisualAge C++ Site

Schema Properties Notebook

The schema's properties notebook shows you the details of the object that is used by Data Access Builder to create a mapping. This object can be a database table, view, or SQL query. This notebook's information cannot be changed. You cannot use Data Access Builder to create database tables or views, or to change their definitions. This must be done using the database administration facility. The data in this notebook is primarily used to provide information about the database for mapping purposes.

The notebook pages vary depending on whether Data Access Builder creates a mapping from a database table, database view, or SQL query:

Database Table Columns page
  • Name: the name of the column. A right-pointing key icon indicates a primary key. A left-pointing key indicates a foreign key.
  • Type: the database data type of the column.
  • Width: the number of characters in a character-type column.
  • Precision: the total number of digits in a decimal-type column.
  • Scale: the number of digits in the fractional part of the number in a decimal-type column.
  • Nulls: refers to whether the column can contain a null value (is nullable). A null value means that no value is set for the column. Key columns cannot be nullable.
  • Comments: comments from the database table
Table page
  • Name of the table
  • Name of the database that contains the table
  • Qualifier for the table name, which is taken from the qualifier field of the mapping's properties notebook.
  • Any comments that the creator included with the table
Foreign Keys page
If Data Access Builder cannot access the constraints information, it displays a message stating that the existence of foreign keys could not be determined. Click on the down arrow in the Constraint text field to see a list of all constraints that apply to the table. When you select a constraint from the list, the Foreign Keys page is updated with the following information:
  • Constraints on the table
  • The delete rule for each constraint
  • The referenced table for each constraint
  • Referenced keys and matching columns for each constraint
Unique Indices page
If the table has unique indices defined, they will be listed on this page in the Index Name box. If you select an item from the Index Name box, the columns that belong to the unique index are listed in the Column Names box. In the Attributes window, you can use the table's unique indices to specify the Data ID for the mapping.
Database View Columns page
  • Name: the name of the column. A right-pointing key icon indicates a primary key. A left-pointing key indicates a foreign key.
  • Type: the database data type of the column.
  • Width: the number of characters in a character-type column.
  • Precision: the total number of digits in a decimal-type column.
  • Scale: the number of digits in the fractional part of the number in a decimal-type column.
  • Nulls: refers to whether the column can contain a null value (is nullable). A null value means that no value is set for the column. Key columns cannot be nullable.
  • Comments: comments from the database table
View page
  • Name of the database view
  • Name of the database that contains the view
  • Qualifier for the view name, which is taken from the qualifier field of the mapping's properties notebook.
  • Any comments that the creator included with the view
SQL Query Columns page
  • Name: the name of the column. A right-pointing key icon indicates a primary key. A left-pointing key indicates a foreign key.
  • Type: the database data type of the column.
  • Width: the number of characters in a character-type column.
  • Precision: the total number of digits in a decimal-type column.
  • Scale: the number of digits in the fractional part of the number in a decimal-type column.
  • Nulls: refers to whether the column can contain a null value (is nullable). A null value means that no value is set for the column. Key columns cannot be nullable.
  • Comments: comments from the database table
Query page
  • Name of the query (specified in the Data Access Builder SmartGuide)
  • Name of the database that contains the columns for the SQL query (specified in the Data Access Builder SmartGuide)
  • Qualifier for the query, which is taken from the qualifier field of the mapping's properties notebook.
  • SQL statement that you entered in the Data Access Builder SmartGuide.


Data Access Builder Workflow


Mapping Properties Notebook