tAS400LastInsertId – Docs for ESB 5.x

Component family

Databases / AS/400

Function

tAS400LastInsertId fetches the last inserted ID from a
selected AS/400 Connection.

Purpose

tAS400LastInsertId obtains the primary key value of
the record that was last inserted in an AS/400 table by a
user.

Basic settings

Schema and Edit
Schema

A schema is a row description. It defines the number of fields to be processed and passed on
to the next component. The schema is either Built-In or
stored remotely in the Repository.

Since version 5.6, both the Built-In mode and the Repository mode are
available in any of the Talend solutions.

Built-in: You create and store
the schema locally for this component only. Related topic: see
Talend Studio User
Guide.

Repository: You have already
created the schema and stored it in the Repository. You can reuse it
in various projects and job flow charts. Related topic: see
Talend Studio User
Guide.

Click Edit schema to make changes to the schema. If the
current schema is of the Repository type, three options are
available:

Component list

Select the relevant tAS400Connection component in the list if more than
one connection is planned for the current job.

Advanced settings

tStat
Catcher
Statistics

Select this check box to collect log data at the component
level.

Dynamic settings

Click the [+] button to add a row in the table and fill
the Code field with a context variable to choose your
database connection dynamically from multiple connections planned in your Job. This feature
is useful when you need to access database tables having the same data structure but in
different databases, especially when you are working in an environment where you cannot
change your Job settings, for example, when your Job has to be deployed and executed
independent of Talend Studio.

Once a dynamic parameter is defined, the Component List
box in the Basic settings view becomes unusable.

For more information on Dynamic settings and context
variables, see Talend Studio User Guide.

Usage

This component is to be used as an intermediary component.

Log4j

The activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User
Guide.

For more information on the log4j logging levels, see the Apache documentation at http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/Level.html.

Limitation

n/a