17.10 - getContractPhase - 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)
Indicates the phase in the parser from which the contract function is being called. The parser phases are as follows:
Parser Phase Meaning
FNC_CTRCT_GET_ALLCOLS_PHASE = 0 Function returns all remote table columns.
FNC_CTRCT_VALIDATE_PHASE = 1 Validates that inputs are correct. Contract function can be called multiple times from this phase.
This phase is currently not used.
FNC_CTRCT_COMPLETE_PHASE = 2 Last call of contract function. Necessary foreign server actions must be completed.
FNC_CTRCT_DDL_PHASE = 3 CREATE SERVER statement execution is being completed and 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.

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


public ContractPhase  getContractPhase();