The tAS400CDC component by default executes the following
RUNCDC command:
<CDC_library_name>/RUNCDC FILE(<Source_library_name>/<Source_table_name>) LIBOUT(<CDC_library_name>) MODE(*DETACHED) MBROPT(*ADD)
Alternatively, you can automate the detachment and attachment process by selecting
the Customize Command check box and adding the following
custom command on the Advanced Settings view of the
tAS400CDC component:
<CDC_library_name>/RUNCDC FILE(<Source_library_name>/<Source_table_name>) LIBOUT(<CDC_library_name>) MODE(*DETACHED) MBROPT(*ADD) DTCHJRN(*YES)
Note that the default
RUNCDC command setup in the
tAS400CDC component reads changes of only one table. If
you want to read changes on multiple (up to 300) tables at the same time and those
tables are all on the same journal, you can use multiple
tAS400CDC components in your Job, add an custom command
<CDC_library_name>/RUNCDC FILE(<Source_library_name>/<Source_table_name1> <Source_library_name>/<Source_table_name2> ... <Source_library_name>/<Source_table_nameN>) LIBOUT(<CDC_library_name>) MODE(*DETACHED) MBROPT(*ADD)
for
the first
tAS400CDC component and disable the command for
other
tAS400CDC components by selecting the
Disable Command check box on the
Advanced
settings view. The first
tAS400CDC component
will execute the
RUNCDC command and extract change data
from all source tables, and other
tAS400CDC components will
simply read data prepared by the first
tAS400CDC component.
For example, the following command reads changes from two tables
EMPLOYEE1 and
EMPLOYEE2 on the
same journal. You can download a sample Job here:
tAS400CDC-multiple-tables.zip.
TALENDCDC/RUNCDC FILE(TALEND/EMPLOYEE1 TALEND/EMPLOYEE2) LIBOUT(TALENDCDC) MODE(*DETACHED) MBROPT(*ADD)"
Alternatively, you can disable command for all tAS400CDC
components and execute the custom command manually on your AS/400 system.