For any Teradata system using QueryGrid, 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