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

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
rin1593638965306.ditamap
dita:ditavalPath
rin1593638965306.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.