User tokens are GoldenGate environment variables that are captured and stored in the trail record for replication. They can be accessed via the
@GETENV function which we have already touched upon the
@GETENV function in the previous section, Using and Defining macros. You can use token data in column maps, stored procedures called by
SQLEXEC, and of course macros.
A vast array of user tokens exists, too many to list in this book. You can use the
TOKENS option of the Extract
TABLE parameter to define a user token and associate it with GoldenGate environment data. For example:
TABLE SRC.CREDITCARD_ACCOUNTS, & TOKENS (TKN_OSUSER = @GETENV("GGENVIRONMENT","OSUSERNAME"), & TKN_DBNAME = @GETENV ("DBENVIRONMENT","DBNAME"), & TKN_HOSTNAME = ...