2.06 - Teradata QueryGrid Stored Procedures, Functions, and Table Operators - 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

Teradata supplies several table operators to import and export data to and from remote systems:

  • QGRemoteImport
  • QGRemoteExport
  • QGInitiatorImport
  • QGInitiatorExport

Teradata also provides the QGExecuteForeignQuery table operator to enable DDL and DCL actions on a remote system, such as CREATE, ALTER, DROP, GRANT, REVOKE, and so on. QGExecuteForeignQuery is invoked by ExecuteForeignSQL when the user runs a query using ExecuteForeignSQL.

These table operators are activated from DIP.

ExecuteForeignSQL is a stored procedure that provides a simple interface for the users to execute basic SQL queries. ExecuteForeignSQL and an install script are provided as part of the Teradata QueryGrid connector package.