Data - AS-400 Middleware

General input parameters

This panel is displayed when data is read from an AS/400.

Data entry

Library

Library containing the files to be exported.

Filter

File name display filter.

Default: "*".

Limit buffer

Optimum size (in Kb) of the generated network buffer.

Object input parameters

This panel is displayed when you select an object if the data source is an AS/400.

Data entry

Select clause

Free text select clause used when reading the data (converted into OPNQRYF format).

You can use the AND and OR comparison operators, and/or enclose the expression between brackets.

Optional entry.

General output parameters

This panel is displayed when the data is inserted into an AS/400 database.

Data entry

Library

Library containing the destination AS/400 files.

Limit buffer

Optimum size (in Kb) of the generated network buffer.

Lists

Insertion mode

Data insertion mode.

Possible values:

Object output parameters

This panel is displayed when you select an object if the data's destination is an AS/400 database.

Data entry

Delete clause

WHERE clause in an SQL query that deletes data from the destination table.

This clause is taken into consideration if the data insertion mode is set to "REPLACE".

The delete query is then constructed as follows: 'delete from <lib>\<table> where <clause>'.

Optional entry.

Lists

Mode

Data insertion mode.

Possible values:

↑ Top of page