Please enable JavaScript to view this site.

For DB2 datastores only, including DB2 changed data capture (CDC) records. The DB2QUAL function returns the qualifier or schema of the DB2 table that is currently being processed directly in a DB2 datastore or a DB2 changed data capture (CDC) datastore.

Category

Specialized

Syntax

DB2QUAL(<source_datastore>)

 

Parameter Descriptions

source_datastore   -  This parameter specifies the alias of the source datastore that contains the DB2 record (native or CDC).

Example

Retrieve the DB2 table qualifier name from the current record in the DB2 change data capture (CDC) datastore CDCIN. Map the result to target field SRC_TBLQUAL.

SRC_TBLQUAL  = DB2QUAL (CDCIN)