Map the database

A nested structure of folders, where each folder represents a table in the database you are mapping. Within each folder is a list of the fields that exist in each table, and a subfolder called Indexes. The Indexes folder contains subfolders for each index of the table. The subfolders contain the fields that make up each index.

You map the tables and fields in the database to the fields in the Surpac database by dragging them from the Source database to the Surpac database in the Mapping detail.

An SQL statement to run on the database after the connection is made.

Note: SQL extra is available only if you ran the DB MAPPER function.

• Selected: The tables in the database are displayed in the Source database.
• Cleared: The tables in the database are not displayed in the Source database.

Note: Available only when you are mapping an ODBC database.

• Selected: The stored queries for the tables in the database are displayed in the Source database.
• Cleared: The stored queries for the tables in the database are not displayed in the Source database.

Note: Available only when you are mapping an ODBC database.

• Selected: Procedures are displayed in the Source database. Procedures are stored in the source database. They are used for data validation and to limit access to data.
• Cleared: Procedures are not displayed in the Source database.

Note: Available only if an ODBC database is being mapped.

• Selected: The system tables created by the database are displayed in the Source database.
• Cleared: The system tables created by the database are not displayed in the Source database.

Note: Available only if an ODBC database is being mapped.

• Selected: Synonyms for database objects are displayed in the Source database. A synonym is an alias for a table, view, or sequence, stored in the source database application.
• Cleared: Synonyms for database objects are not displayed in the Source database.

Note: Available only when you are mapping an ODBC database.

• Selected: You are prompted for an id when you connect to the database.
• Cleared: You are not prompted for an id when you connect to the database.

Note: Available only if an ODBC database is being mapped.

An SCL statement that you can use to set roles for an Oracle database.

Note: Available only if an ODBC or Oracle database is being mapped.

The tables that are available to be mapped in your database. For example, if you enter "db" all of the tables that have names starting with "DB" are active, and other tables are unavailable.

Note: Available only when you are mapping an ODBC database.

The tables that are available to be mapped in your database. For example, if you enter "geologist" all the tables available to the users with the role "geologist" are available.

Note: Available only when you are mapping an ODBC database.

The type of information contained in the field. Options are:

• character
• real
• integer
• datetime
• duration
• boolean
• memo

• Selected: Null values are permitted in the field.
• Cleared: Null values are not permitted in the field. If a process attempts to add a null value to this field a warning message is written to the message window.

The case that the field values are written in. Options are:

• lower
• mixed
• upper

Note: Available only if character or memo are selected as the Field type.

The list of character values that you can view in, or add to, the field. You can enter a list of values with each entry separated by a semicolon (;).

Note: Available only if character is selected as the Field type.

The number of decimal places that you can view in, or add to, the field.

Note: Available only if integer or real are selected as the Field type.

Lowest value that you can view in, or add to, the field.

Note: Available only if integer or real are selected as the Field type.

Highest value that you can view in, or add to, the field.

Note: Available only if real is selected as the Field type.