The DB2TBLNAME function returns the name of the DB2 table currently being processed in a DB2 changed data capture (CDC) source datastore or directly in a DB2 datastore.
Category
Specialized
Syntax
DB2TBLNAME(<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 name from the current record in the DB2 change data capture (CDC) datastore CDCIN. Map the result to target field SRC_TBLNAME.
SRC_TBLNAME = DB2TBLNAME (CDCIN)Note: Precisely recommends using the RECNAME function which returns the alias of the DESCRIPTION corresponding to the current record from the source datastore.