You can configure Db2 connector to read data using external tables. Refer to DB2 connector support for external tables for information on
databases that can be used.
Before you begin
You must configure a database connection for the Db2®
connector.
Procedure
- On the job design canvas, double-click the Db2 connector icon.
- Click the Output tab, then select
the output link that you want to edit.
- Click the Properties tab.
- On the Properties tab in the Usage section,
specify how the connector operates in a job.
- In the Table name field, specify the table that you want to
read.
- Set the Generate SQL property to
Yes.
- Set the Session > Use external tables
property to Yes.
- If needed, configure external table configuration properties.
- You can configure other Db2 connector properties that are available in current
mode.
- Click OK
- External table mode configuration properties in read mode
- You can provide additional properties to control read operation when external tables are used.
When no values are defined, defaults will be used.
- Directory for named pipe (Unix only)
- Type: String
- Specifies the location where the named pipe that is used by the external tables operation must
be created. This property applies to Unix systems only.
- Other options
- Type: String
- Extra options to be passed to the external table statement. The supported values are described
in the Create External Table section of the IBM Knowledge Center that is dedicated to target Db2
database. Note, that some of the options are already in use to allow read and write operation within
the DataStage job and cannot be redefined inside the Other options property.
Refer to troubleshooting section for additional information.