2.10 - Confirming the QueryGrid Functions - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K
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