July 31, 2023

Procedure – Docs for ESB Jdbc 7.x

  2. Talend for ESB Docs
  3. Docs 7.x
  4. Procedure – Docs for ESB Jdbc 7.x

Procedure

  1. Drag and drop a tDBSQLRow component from the
    Palette to the design workspace.

    Procedure_1.png

  2. Double-click tDBSQLRow to open its Basic settings view.

    Procedure_2.png

  3. Select Repository in the Property Type list as the ODBC connection has been
    configured and saved in the Repository. The follow-up fields gets filled in
    automatically.

    For more information on storing DB connections in the Repository, see

    Talend Studio User Guide    .
  4. The Schema is built-in for this Job and it
    does not really matter in this example as the action is made on the table
    auto-increment and not on data.
  5. The Query type is also built-in. Click on the
    […] button next to the Query statement box to launch the SQLbuilder editor,
    or else type in directly in the statement box:

    Alter table <TableName> auto_increment = 1
  6. Press Ctrl+S to save the Job and F6 to run.

    The database autoincrement is reset to 1.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 7.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x