Determines whether the driver creates the internal files required for a relational map of the native data model when establishing a connection.
Valid Values
0 | 1 | 2 | 3 | 4
Behavior
If set to 0 (NotExist), the driver uses the current group of internal files specified by the Schema Map (SchemaMap) option. If the files do not exist, the driver creates them.
If set to 1 (ForceNew), the driver deletes the group of internal files specified by the Schema Map option and creates a new group of these files at the same location.
If set to 2 (No), the driver uses the current group of internal files specified by Schema Map option. If the files do not exist, the connection fails.
If set to 3 (Session), the driver uses memory to store the internal configuration information and relational map of the native data model. After the session, the view is discarded.
If set to 4 (OnChange), the driver checks for changes to the native data model for CRM apps. If changes to the schema are detected, the driver deletes the group of internal files specified by the Schema Map option and creates a new group of these files at the same location. For ERP apps, 4 (OnChange) is ignored, and the driver uses the current group of internal files specified by Schema Map.
Notes
The internal files share the same directory as the schema map's configuration file. This directory is specified with the Schema Map (SchemaMap) connection option.
You can refresh the internal files related to an existing relational view of your data with the SQL extension Refresh Map. Refresh Map runs a discovery against your native data and updates your internal files accordingly.
The default behavior for ERP apps is different from the default behavior for CRM apps. For ERP apps, the default setting 0 (OnChange) is ignored, and the driver uses the current group of internal files specified by the Schema Map (Schema Map) option. If you are using the driver with an ERP app, the 1 (ForceNew) or 3 (Session) settings can be used to pick up changes made to the native data model. Alternatively, you may use the Refresh Map SQL extension to discover changes to the native data model.
The internal files share the same directory as the schema map's configuration file. This directory is specified with the Schema Map (SchemaMap) connection option.