Confirm QueryGrid Functions | QueryGrid - Confirming the QueryGrid Functions - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem
For any Teradata system using QueryGrid, 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