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 and Description
| Parameter | Description |
|---|---|
| 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)