Syntax - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantage™
public class  com.teradata.fnc.Tbl  extends java.lang.Object{
    public static final int TBL_MODE_VARY;
    public static final int TBL_MODE_CONST;
    public static final int TBL_NOOPTIONS;
    public static final int TBL_LASTROW;
    public static final int TBL_NEWROW;
    public static final int TBL_NEWROWEOF;
    public static final int TBL_PRE_INIT;
    public static final int TBL_INIT;
    public static final int TBL_BUILD;
    public static final int TBL_BUILD_EOF;
    public static final int TBL_FINI;
    public static final int TBL_END;
    public static final int TBL_ABORT;
    public static final int UNDEF_DT;
    public static final int CHAR_DT;
    public static final int VARCHAR_DT;
    public static final int BYTE_DT;
    public static final int VARBYTE_DT;
    public static final int GRAPHIC_DT;
    public static final int VARGRAPHIC_DT;
    public static final int BYTEINT_DT;
    public static final int SMALLINT_DT;
    public static final int INTEGER_DT;
    public static final int REAL_DT;
    public static final int DECIMAL1_DT;
    public static final int DECIMAL2_DT;
    public static final int DECIMAL4_DT;
    public static final int DECIMAL8_DT;
    public static final int DATE_DT;
    public static final int TIME_DT;
    public static final int TIMESTAMP_DT;
    public static final int INTERVAL_YEAR_DT;
    public static final int INTERVAL_YTM_DT;
    public static final int INTERVAL_MONTH_DT;
    public static final int INTERVAL_DAY_DT;
    public static final int INTERVAL_DTH_DT;
    public static final int INTERVAL_DTM_DT;
    public static final int INTERVAL_DTS_DT;
    public static final int INTERVAL_HOUR_DT;
    public static final int INTERVAL_HTM_DT;
    public static final int INTERVAL_HTS_DT;
    public static final int INTERVAL_MINUTE_DT;
    public static final int INTERVAL_MTS_DT;
    public static final int INTERVAL_SECOND_DT;
    public static final int TIME_WTZ_DT;
    public static final int TIMESTAMP_WTZ_DT;
    public static final int BLOB_REFERENCE_DT;
    public static final int CLOB_REFERENCE_DT;
    public static final int UDT_DT;
    public static final int BIGINT_DT;
    public static final int DECIMAL16_DT;
    public static final int NUMBER_DT;
    public static final int FNC_DATATYPESETSIZE;
    public static final int ERRUDFJTBLGETLENWCOL;
    public static final int ERRUDFJTBLGETPRECSNWCOL;
    public static final int ERRUDFJTBLGETSCALEWCOL;
    public int  getMode() throws java.io.IOException;
    public int  getPhase(int[]) throws java.io.IOException;
    public int  getPhaseEx(int[], int) throws java.io.IOException;
    public  com.teradata.fnc.Tbl();
    public void  allocCtx(java.lang.Object)
       throws java.io.IOException, java.sql.SQLException;
    public void  allocCtx(int)
       throws java.io.IOException, java.sql.SQLException;
    public boolean  control() throws java.io.IOException;
    public int[]  getColDef()
       throws java.io.IOException, java.sql.SQLException;
    public int  getLength(int)
       throws java.io.IOException, java.sql.SQLException;
    public int  getPrecision(int)
       throws java.io.IOException, java.sql.SQLException;
    public int  getScale(int)
       throws java.io.IOException, java.sql.SQLException;
    public boolean  optOut() throws java.io.IOException;
    public boolean  abort() throws java.io.IOException;
    public boolean  firstParticipant()
       throws java.io.IOException, java.sql.SQLException;
    public void  setCtrlCtx(java.lang.Object)
       throws java.io.IOException, java.sql.SQLException;
    public java.lang.Object  getCtrlCtx()
       throws java.io.IOException, java.lang.ClassNotFoundException,
       java.sql.SQLException;
    public void  setCtxObject(java.lang.Object)
       throws java.io.IOException, java.sql.SQLException;
    public void  setCtxObject(byte[])
       throws java.io.IOException, java.sql.SQLException;
    public java.lang.Object  getCtxObject()
       throws java.io.IOException, java.lang.ClassNotFoundException,
       java.sql.SQLException;
    public byte[]  getCtxObject(byte[])
       throws java.io.IOException, java.lang.ClassNotFoundException,
       java.sql.SQLException;
}