TraceObj Constructor - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

Use this constructor to wrap a Java object containing a value that you want to write to a column in a temporary trace table using DbsInfo.traceWrite().

The first argument to this constructor is the Java object to wrap. The second argument is a static constant defined by the TraceObj class that identifies the SQL data type of the target column in the trace table. Use the following table to determine the type of Java object that you need to pass as the first argument and the static constant that you need to pass as the second argument.

IF the SQL data type of the trace table column is … THEN the first argument to this constructor is a … AND the second argument to this constructor is …
INTEGER java.lang.Integer TraceObj.INTEGER_DBS
BYTEINT java.lang.Byte TraceObj.BYTEINT_DBS
SMALLINT java.lang.Short TraceObj.SMALLINT_DBS
BIGINT java.lang.Long TraceObj.BIGINT_DBS
DOUBLE java.lang.Double TraceObj.DOUBLE_DBS
DATE java.sql.Date TraceObj.DATE_DBS
TIME java.sql.Time TraceObj.TIME_DBS
TIME WITH TIME ZONE java.sql.Time TraceObj.TIMEWZONE_DBS
TIMESTAMP java.sql.Timestamp TraceObj.TIMESTAMP_DBS
TIMESTAMP WITH TIME ZONE java.sql.Timestamp TraceObj.TIMESTAMPWZONE_DBS
REAL java.lang.Double TraceObj.REAL_DBS
FLOAT java.lang.Double TraceObj.FLOAT_DBS
VARBYTE byte[] TraceObj.VARBYTE_DBS
BYTE byte[] TraceObj.BYTE_DBS
DECIMAL (n, m) java.math.BigDecimal TraceObj.DECIMAL_DBS
NUMERIC (n, m) java.math.BigDecimal TraceObj.NUMERIC_DBS
NUMBER(n, m) java.math.BigDecimal TraceObj.NUMBER_DBS
INTERVAL YEAR java.lang.String TraceObj.INTERVALYEAR_DBS
INTERVAL YEAR TO MONTH java.lang.String TraceObj.INTERVALYEARMON_DBS
INTERVAL MONTH java.lang.String TraceObj.INTERVALMON_DBS
INTERVAL DAY java.lang.String TraceObj.INTERVALDAY_DBS
INTERVAL DAY TO HOUR java.lang.String TraceObj.INTERVALDAYHOUR_DBS
INTERVAL DAY TO MINUTE java.lang.String TraceObj.INTERVALDAYMIN_DBS
INTERVAL DAY TO SECOND java.lang.String TraceObj.INTERVALDAYSEC_DBS
INTERVAL HOUR java.lang.String TraceObj.INTERVALHOUR_DBS
INTERVAL HOUR TO MINUTE java.lang.String TraceObj.INTERVALHOURMIN_DBS
INTERVAL HOUR TO SECOND java.lang.String TraceObj.INTERVALHOURSEC_DBS
INTERVAL MINUTE java.lang.String TraceObj.INTERVALMIN_DBS
CHAR CHARACTER SET LATIN java.lang.String TraceObj.LATIN_CHAR_DBS
VARCHAR CHARACTER SET LATIN java.lang.String TraceObj.LATIN_VARCHAR_DBS
CHAR VARYING CHARACTER SET LATIN java.lang.String TraceObj.LATIN_CHARVARYING_DBS
LONG VARCHAR CHARACTER SET LATIN java.lang.String TraceObj.LATIN_LONGVARCHAR_DBS
CHAR CHARACTER SET UNICODE java.lang.String TraceObj.UNICODE _CHAR_DBS
VARCHAR CHARACTER SET UNICODE java.lang.String TraceObj.UNICODE _VARCHAR_DBS
CHAR VARYING CHARACTER SET UNICODE java.lang.String TraceObj.UNICODE _CHARVARYING_DBS
LONG VARCHAR CHARACTER SET UNICODE java.lang.String TraceObj.UNICODE _LONGVARCHAR_DBS