Creating an ODBC Data Source to Run a DB2 for z/OS Stored Procedure Transformation

Back Next

General Tab

On the General
tab in the PowerExchange Data Source
wizard, enter the following optional properties for a PowerExchange data source definition.

Integration Mask: The integration mask. If you specify DFN, the PowerExchange data source type is returned as follows:

DETAIL:NRDB

Default is blank, which returns the following string:

DETAIL

Informatica recommends using the default value.

Set this property only at the direction of Informatica Global Customer Support.

Corresponding ODBC Parameter:
COMPATIBILITY
Maximum Rows: The maximum rows for retrieval.

Valid values are 0 to 2147483647.

Default is 0, which indicates unlimited rows.

Corresponding ODBC Parameter:
MAXROWS
Pacing Size: The number of rows or kilobytes. Set this property when an application, such as an interactive application, cannot keep pace with the flow of data from the PowerExchange Listener.

For maximum performance, set this property to 0.

Default is the value of the API rows_requested parameter.

Corresponding ODBC Parameter:
PACESIZE
As KB: Select this option to specify the pacing size in kilobytes.

Default is As KB
.

Corresponding ODBC Parameter:
INTERPRETASROWS
As Rows: Select this option to specify the pacing size in rows.

Default is As KB
.

Corresponding ODBC Parameter:
INTERPRETASROWS
Compress: Select this option to compress data.

This option is cleared by default.

Corresponding ODBC Parameter:
COMPRESS
Encrypt: Select this option to encrypt data.

This option is cleared by default.

Corresponding ODBC Parameter:
ENCRYPT, as follows:

If this option is selected, ENCRYPT=N.

If this option is cleared, ENCRYPT=Y.
Option: The encryption option, which is one of the following:

DES
. Data is encrypted by using Digital Encryption Standard (DES) algorithm.

RC2
. Data is encrypted by using the RSA security algorithm.

If you select an encryption option, you must select an encryption level in the Level
list.

Corresponding ODBC Parameter:
ENCRYPT, as follows:

If the DES
option is selected, ENCRYPT=DES.

If the RC2
option is selected, ENCRYPT=RC2.
Level: Required if you select the DES
or RC2
encryption option.

The encryption level.

The options are:

1
. Data is encrypted by using:

For DES: 56-bit key encryption

For RC2: 56-bit key encryption

2
. Data is encrypted by using:

For DES: Triple DES 164-bit key encryption

For RC2: 64-bit key encryption

3
. Data is encrypted by using:

For DES: Triple DES 164-bit key encryption

For RC2: 128-bit key encryption

Default is 1
if the DES
or RC2
encryption option is selected.

Corresponding ODBC Parameter:
ENCRYPTLEVEL
MQ Get Opt: The type of read operation to be performed from an MQSeries queue.

The options are:

BROWSE
. Reads a copy of the data on the queue.

READ
. Reads the data and removes it from the queue.

Default is READ
.

Corresponding ODBC Parameter:
MQGETOPT
Application: The application name, which is used as part of the audit trail for data extractions by the PowerExchange Listener.

Corresponding ODBC Parameter:
DTLAPP

Rename Saved Search

Table of Contents

Creating an ODBC Data Source to Run a DB2 for z/OS Stored Procedure Transformation

Creating an ODBC Data Source to Run a DB2 for z/OS Stored Procedure Transformation

General Tab

General Tab