In this section: |
This section describes some tips and tricks that can be used.
Records for the destination table can be filtered by including an iFL test. If the test is present, it is evaluated on each row. If the test evaluates as true, then the record is not written to the destination.
Some methods to indicate that a specific record should be omitted, might be to include an attribute in the root of the XML that is returned to the iterator, which would normally become the next destination record. For example, the test might be:
_iwxpath(/root/@omit)=true
A special register (SREG) can also be set with a predetermined name, such as omit, and the test would then be:
_sreg('omit', 'false')='true'
The Data Tools Project (DTP) does not provide a predefined JDBC driver template for SQL Server Version 2008. However, the generic JDBC driver definition can be used.
To use the generic JDBC driver definition:
com.microsoft.sqlserver.jdbc.SQLServerDriver
For example:
iWay Software |