FNC_TblOpGetContractPhase Function | C Library Functions | Teradata Vantage - 17.10 - FNC_TblOpGetContractPhase - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Returns the phase in the parser from which the contract function is being called:

Parser Phase Meaning
FNC_CTRCT_GET_ALLCOLS_PHASE = 0 Function returns all remote table columns.
FNC_CTRCT_VALIDATE_PHASE = 1 Inputs are correct.
Contract function can be called multiple times from this phase.
This phase is not used.
FNC_CTRCT_COMPLETE_PHASE = 2 Last call of contract function. Any foreign server actions that must be done must be completed.
FNC_CTRCT_DDL_PHASE = 3 Execution of CREATE SERVER statement is being completed. Connectivity must be verified.
FNC_CTRCT_DEFINE_SERVER_PHASE = 4 CREATE VIEW or CREATE MACRO statement is being executed. Custom clause data may be invalid.



Usage Notes

This routine is callable on a PE vproc only by a table operator.