Please enable JavaScript to view this site.

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 Descriptions

source_datastore  -  This parameter specifies the name 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 changed data capture (CDC) source 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.