Writing the data into AS/400
-
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
field.123456789101;George;Bismarck2;Abraham;Boise3;Taylor;Nashville4;William;Jefferson City5;Alexander;Jackson6;James;Boise7;Gerald;Little Rock8;Tony;Richmond9;Thomas;Springfield10;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.
Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Login
0 Comments