Input Source Override - Database (-ID)

Use the Input Source Override - Database execution command (-ID) to override specifications in the compiled map file for a specific input card for a single execution of a map. Only those adapter settings specified are used to override the settings compiled into the map.

For example, if the WorkArea option (W or !W) is not specified, the WorkArea setting compiled into the map is used.

-IDcard_num[M['filename']]
[W|!W][Rcount:interval][B][EN][EA][EF][ES][EW] [AF][AI][PM][PB][PC][F'n'][U][!U] [K['filename']|[+'filename']|[U'filepath']|[U]| [1'filename']|[1+'filename']|[U1'filepath']|[U1]] {src-adptr-cmd|.}
Option
Description
card_num
This is the card number of the input to override.
M'filename'
This is the metadata (XML schema or DTD) file location of the input card to override.
Specify filename as an absolute path along with the file name and enclosed in single quotes, for the metadata when parsing input XML. An example is:
M'k:\my_project_folder\myschema.xml'
Use this command option to override the Metadata location setting for the root type specified on an input card in the Map Designer GUI.
W
After a map runs for the first time, the work area that is created for the input card is not deleted. Then, on subsequent executions of the same map, the data for this input card is not validated and the work area information for the card is retrieved from the existing work area.
!W
Input's work area is created when map execution begins.
Rcount:interval
Specify Retry settings. If the source is unavailable, the adapter attempts to access the source as many times as specified by the count setting at the interval specified by the interval setting.

count number of attempts to access the database

interval number of seconds to wait between attempts.

If this option is not specified, the Retry settings compiled into the map are used. To eliminate adapter retry, specify R0:0.

B
If the map, burst, or card does not complete successfully, roll back any changes that were made to this data source. If this option is not specified, the OnFailure setting compiled into the map is used.
EN
Use this command option to never call the external parser for document verification.
EA
Use this command option to always call the external parser for document verification.
EF
Use this command option to call the external parser for document verification only if validation fails.
ES
Use this command option to call the external parser for document verification only if validation is successful.
EW
Use this command option to call the external parser for document verification only for the well-formed document.
AF
Use this command option to fail on adapter warnings.
AI
Use this command option to ignore adapter warnings.
PM
Use this command option to apply the OnSuccess and OnFailure settings based on the success or failure of the map execution.
PB
Use this command option to apply the OnSuccess and OnFailure settings based on the success or failure of each burst.
PC
Use this command option to apply the OnSuccess and OnFailure settings based on the success or failure of the input card processing
Fn
FetchUnit defines the number of units of data to retrieve. The default value for FetchUnit is S (unspecified all).
U
Use this command option to apply the burst setting.
!U
Use this command option to not burst (integral mode).
K
When the map, burst, or card runs, no backup file will be created.
K'filename'
When the map, burst, or card runs, a backup file will always be created to filename. If filename' is not an absolute path, the map directory will be appended as a prefix to it.
K+'filename'
When the map, burst, or card runs, a backup file will always be appended to filename. If filename' is not an absolute path, the map directory will be appended as a prefix to it.
KU'filepath'
When the map, burst, or card runs, a backup file will always be created using a unique backup name in the directory filepath. If 'filepath' is not an absolute path, the map directory will be appended as a prefix to it.
KU
When the map, burst, or card runs, a backup file will always be created using a unique backup name in the map directory.
K1'filename'
If the map, burst, or card does not successfully complete, a backup file will be created to filename. If 'filename' is not an absolute path, the map directory will be appended as a prefix to it.
K1+'filename'
If the map, burst, or card does not successfully complete, a backup file will be appended to filename. If 'filename' is not an absolute path, the map directory will be appended as a prefix to it.
KU1'filepath'
If the map, burst, or card does not successfully complete, a backup file will be created using a unique backup name in the directory filepath. If 'filepath' is not an absolute path, the map directory will be appended as a prefix to it.
KU1
If the map, burst, or card does not successfully complete, a backup file will be created using a unique backup name in the map directory.
src-adptr-cmd
Specify the settings for the source using the adapter-specific commands. See the specific database adapter documentation in the Resource Adapters documentation.
.
Use Command in the compiled map file.