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

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
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.

Syntax

int
FNC_TblOpGetContractPhase()

Usage Notes

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