QGInitiatorImport
QGInitiatorImport is the initiator import function that is invoked when the query is initiated from Teradata and needs to access metadata and fetch data from a remote host. This initiator import connector function is used to import data from any remote host.
QGInitiatorExport
QGInitiatorExport is the initiator export function that is invoked when the query is initiated from Teradata to access metadata and export data to a remote host. This initiator export connector function is used to export data to any remote host.
Example: Using QGInitiatorImport and QGInitiatorExport
CREATE FOREIGN SERVER Hive_1 USING LINK(‘QG_hive1’) DO IMPORT WITH TD_SYSFNLIB.QGInitiatorImport, DO EXPORT WITH TD_SYSFNLIB.QGInitiatorExport;
QGRemoteImport
QGRemoteImport is the remote import function that is invoked when the query is initiated by a remote host to transfer data to the local Teradata system. This remote import function is used for data transfer from any remote data source.
QGRemoteExport
QGRemoteExport is the remote export function that is invoked when the query is initiated by a remote host to access data from the local Teradata system. This remote import function is used to export data to any remote host.
QGExecuteForeignQuery
QGExecuteForeignQuery is the function that is invoked when a stored procedure is invoked to execute a DDL or DML request on the remote system. This allows you to execute CREATE TABLE, DROP TABLE, GRANTs, and so on, from a local Teradata system on the remote host.
Example: Using QGExecuteForeignQuery
CREATE FOREIGN SERVER hive_efssp USING LINK(‘QG_hive1’) DO IMPORT WITH TD_SYSFNLIB.QGExecuteForeignQuery;