How to: |
The following are some of the parameters that affect DataMigrator:
Turns on iWay messaging for the log.
Affects SORTMERGE or NESTEDLOOP logic.
Affects how SQL is handed to remote servers.
Turns on continental decimal notation for flat file copies.
Controls whether NULL values in a comparison affect the nullability of the result.
SET parameter = option
where:
Is the setting you wish to change.
Is a valid value for the parameter.
The following sets the CDN SET parameter to ON.
SET CDN = ON
When new target tables are created, by default, the resulting target columns inherit the NULLABLE setting of their corresponding source columns.
To set the nullability of target columns, use the following syntax:
SET TARGET_ATTR=ON|PROPAGATE
where:
Makes all non-key target columns NULLABLE (MISSING=ON).
All non-key target columns inherit the nullability of their source columns. This is the default.
This setting can be used in a profile, where it will affect all new target tables.
When DataMigrator attempts to insert rows into a target relational database table, they may be rejected due to a unique index, not null, or other constraint violations. When rows are rejected, the error messages are written to the Log Table. This can fill up the log, and it may not be necessary to see the message for every rejected row to determine the problem.
The maximum number of errors written to the log can be restricted with the following command:
SET DBMSMSGLIMIT=nnnn
where
Is the maximum number of errors.
Note: The job's processing continues, although further errors are not logged.
This setting can be used in a profile, where it will affect all new target tables, or in a stored procedure that is executed before the data flow loads the target table.
The DATETIME_PROCESS setting allows you to specify the source for the current date and time in SQL SELECT statements from Oracle tables using CURRENT_TIMESTAMP(0).
The syntax is:
SQL SET DATETIME_PROCESS=SERVER|DBMS
END
where:
Obtains the current date and time from the iWay server. This is the default.
Obtains the current date and time information from the relational database. This is only effective for queries that can use automatic pass through and only those that use the function CURRENT_TIMESTAMP(0).
This syntax should be used even if it is included in a profile, which affects all queries run on the server.
If the query cannot use APT (for example, if the source is a flat file) the following message is generated:
(FOC14070) Query cannot go APT to evaluate CURRENT_TIMESTAMP
iWay Software |