Database-specific adapter commands on the command line
For a database-specific adapter, an existing data source which is a file, can be overridden and specified to be a database using the Input Source Override - Database execution command (-ID). Or, you can override an existing data target that is a table in one database with a table in a different database using the Output Source Override - Database execution command (-OD). For information about all of the options to use within these database execution commands, refer to the Execution Commands documentation.
The values specified using the Input Source Override - Database execution command (-ID) and the Output Source Override - Database execution command (-OD) can be used to designate a query or table to be used as the data source or target, or to override one or more of the adapter commands of an existing database definition as follows:
- using an .mdq file
Specify the name of an .mdq file and the name of a particular database that will override the appropriate adapter settings. In this usage, the .mdq file must be available at map execution time. The values in the .mdq file will override all values defined in the map.
- not using an .mdq file
Use a command string that includes all of the database adapter commands necessary to specify the desired settings for a map. An .mdq file is not used.