August 15, 2023

Writing the data into AS/400 – Docs for ESB 6.x

Writing the data into AS/400

  1. Double-click tFixedFlowInput to open its
    Basic settings view.

    components-tas400input_s1_tfixedflowinput.png

  2. 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.

    components-tas400input_s1_tfixedflowinput_schema.png

    Click OK to close the [Schema] dialog box and accept the propagation prompted by the
    pop-up dialog box.
  3. In the Mode area, select Use Inline Content (delimited file) and enter the
    following user information in the Content
    field.

  4. Double-click tAS400Output to open its Basic settings view.

    components-tas400input_s1_tas400output.png

  5. In the Host, Database, Username and
    Password fields, enter the information
    required for the connection to AS/400.
  6. In the Table field, specify the table into which you want
    to write the data. In this example, it is doct1018.
  7. 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
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x