Open topic with navigation

You are here: Menu Commands > Database > Database > Edit database definition
GEOVIA Surpac

Edit database definition

You can use this function to correct problems in mapping field names, in the .ddb file, to field names in the database to which it connects.

To run this function: Choose Database > Database > Edit database definition, or Design > Blast design > Database > Edit blast database definition, or...

  • In the Function Chooser, type DDB EDITOR, and press ENTER.
  • In the Function Chooser, type BLAST DDB EDITOR, and press ENTER.
Fields on the Edit the database definition form

Field Description
File name Name of the .ddb file to edit.
Files of type File type to open. There is no need to change this to a file type other than .ddb.
Password required to open database
  • Selected. When you click Next, you are prompted to enter the user name and password to use when the database is opened. Select this check box if the database is password-protected, or you need to open it as a user that has specific permissions on the database.
  • Cleared. You are not prompted to enter a user name and password.
Next Opens the Map the database form so you can map the field.

 

Fields on the Map the database form
Field Description
Source 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.
Mapping detail The tables and fields in the Surpac database. The Mandatory Tables (that is, the collar and survey tables) must be mapped. Other tables are optional and you map them only if you want to use the data in those tables.
Database specifics
SQL extra

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.
Tables
  • 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.
Views
  • 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.
Procedures
  • 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.
Systables
  • 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.
Synonyms
  • 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.
Refresh the tree button Updates the Source database folders to show only the database specifics you have selected. That is, the Tables, Views, Procedures, Systables, or Synonyms.
Prompt id
  • 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.
Oracle role

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.
Table mask

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.
User mask

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.
Field and index information
Field type

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

  • character
  • real
  • integer
  • datetime
  • duration
  • boolean
  • memo
Nulls allowed
  • 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.
Length The number of characters that you can view in, or add to, the field. The default value is the maximum length of the field in the Source database.
Case

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.
Valid values

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.
No decimals

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.
Low bound

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.
High Bound

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

Note: Available only if real is selected as the Field type.
Prev button Go to the previous form in the mapping process.
Finish button Finish the mapping process and connect to the database.
Cancel button Cancels the mapping process.
Output

The .ddb file is updated with any mapping changes that you made.

ClosedTroubleshooting
See also

Open topic with navigation