Data Transformation Engine Execution Commands Reference Guide

Chapter 3 - Examples Overriding a Database Target
Execution Commands Reference Guide
54
Option Description
that precede it on the command line.
-F
Fail on the return of any warning code.
-Y10:2
If any non-data file resource is unavailable, such as
the map file, audit log file, work file, and so on, up to
ten attempts should be made at two-second intervals
to access the unavailable resource.
Overriding a Database Target
Suppose you want to run the map multitran.hp, overriding some of the settings
for the fourth output card, which is a database target.
Use the following command:
/mercator/mercator multitran.hp –G –OD4R5:3B “‘-DELETE –TRACE
ERROR’”
Option Description
multitran.hp
This specifies the name of the map to be executed,
multitran.hp.
-G
All item properties (including size, presentation, and
restrictions) are fully validated.
-OD4R5:3B “‘…’”
This changes settings for the database target for the
data of output card #4 as follows:
R5:3 If the database resource is unavailable,
attempt to make the connection five more
times at three-second intervals
B If the map does not complete successfully,
roll back any changes made to the database
table
“‘-DELETE –TRACE
ERROR’”
These database-specific adapter commands
(described in the Resources Adapters Reference
Guide) indicate that all rows in the target database
table should be deleted before processing the output
data and a trace file should be generated that only
contains error information.