2.06 - Confirming the QueryGrid Functions - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

Product
Teradata QueryGrid
Release Number
2.06
Published
September 2018
Language
English (United States)
Last Update
2018-11-26
dita:mapPath
blo1527621308305.ditamap
dita:ditavalPath
ft:empty
Before continuing with the configuration of the Teradata Initiator connector, you must confirm the QueryGrid initiator and target functions.
  1. 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	?	
    ...
  2. 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