Double-click tFixedFlowInput to open its
Basic settings view.
Click the [...] button next to Edit
schema and in the [Schema]
dialog box define the schema by adding three columns: id of Integer type, and name
and city of String type.
Click OK to close the [Schema] dialog box and accept the propagation prompted by the pop-up dialog box.
In the Mode area, select Use Inline Content (delimited file) and enter the
following user information in the Content
1;George;Bismarck 2;Abraham;Boise 3;Taylor;Nashville 4;William;Jefferson City 5;Alexander;Jackson 6;James;Boise 7;Gerald;Little Rock 8;Tony;Richmond 9;Thomas;Springfield 10;Andre;Nashville
Double-click tAS400Output to open its Basic settings view.
- In the Host, Database, Username and Password fields, enter the information required for the connection to AS/400.
- In the Table field, specify the table into which you want to write the data. In this example, it is doct1018.
- Select Drop table if exists and create from the Action on table drop-down list, and select Insert from the Action on data drop-down list.