The ISREFRESH function identifies records that come from the DB2z Dynamic Refresh command. Return 1 (TRUE) if refresh, 0 (FALSE) if not.
Category
Changed Data Capture
Syntax
ISREFRESH()Parameter and Description
This function has no parameters.
Example
If the record is a DB2z Dynamic Refresh record, then
ISREFRESH returns TRUE and can be checked as below to redirect the record to the specific target as we are redirecting to TARGET_REFRESH named target below, it could be any valid target datastore.IF ISREFRESH() = TRUE
{ REPLICATE(TARGET_REFRESH) }
ELSE
{ REPLICATE(TARGET) }