Before continuing with the configuration of the Teradata Initiator connector, you must confirm the QueryGrid initiator and target functions.
-
Check for the existence of the qginitiator and qgremote functions by running the following query on both the initiator and target (if applicable) systems.
help user td_sysfnlib; Help information returned. 531 rows. Total elapsed time was 1 second. Table/View/Macro name Kind Comment --------------------- ---- -------- ... QGEXECUTEFOREIGNQUERY L ? QGEXECUTEFOREIGNQUERYCONTRACT C ? QGINITIATOREXPORT L ? QGINITIATOREXPORTCONTRACT C ? QGINITIATORIMPORT L ? QGINITIATORIMPORTCONTRACT C ? QGREMOTEEXPORT L ? QGREMOTEEXPORTCONTRACT C ? QGREMOTEIMPORT L ? QGREMOTEIMPORTCONTRACT C ? ...
-
If the functions do not exist, run the DIP script systems functions using the DIP utility to add these to the database.
DIPSYSFNC - System Functions