Procedure
-
Add the following components by typing the component names on the design
workspace or dropping them from the Palette:
-
a tRunJob component, to call the child Job,
-
a tMysqlConnection component (displayed as tDBConnection_1), to open the MySQL database connection,
-
a tMysqlInput component (displayed as tDBInput_1), to read the data written to the MySQL database by the child Job.
-
a tLogRow component to display the data on the console,
-
a tMysqlCommit component (displayed as tDBCommit_1) to commit data upon transaction and close the database connection.
-
- Connect the tRunJob component to the tMysqlConnection component using a Trigger > OnSubjobOk connection.
- Connect the tMysqlConnection component to the tMysqlInput component using a Trigger > OnSubjobOk connection.
- Connect the tMysqlInput component to the tLogRow component using a Row > Main connection.
-
Connect the tMysqlInput component to the
tMysqlCommit component using a
Trigger > OnSubjobOk connection.