ColumnDefinition Methods - 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™

getCharset()

public int getCharset()

Provides access to the character set of the column.

getDisplayLength()

public int getDisplayLength()

Provides access to the length of the data type of the column.

getJsonFormat()

public byte getJsonFormat()

Provides access to the JSON storage format of the JSON column.

getName()

public java.lang.String getName()

Returns a string with the column name.

getPeriodType()

public int getPeriodType()
Returns an int value indicating the Period type of the column. Valid values are as follows:
NOT_PERIOD = 0
    PERIOD_DATE = 1
    PERIOD_TIME = 2
    PERIOD_TIME_WTZ =3
    PERIOD_TIMESTAMP = 4
    PERIOD_TIMESTAMP_WTZ = 5

getPrecision()

public int getPrecision()

Provides access to the current precision for a DECIMAL column.

getScale()

public int getScale()

Provides access to the scale for a DECIMAL column.

getType()

public com.teradata.fnc.TeradataType getType()

Returns the Teradata type of the column.

getUDTName()

public String getUdtName()

Returns a String that is the UDT name of the column.

isTimeZone()

public boolean isTimeZone()

Provides access to the time zone of a TIME or DATE type column.

setCharset(int)

public void setCharset(int  cset)
Parameter Name Description
cset
  • A value of 1 specifies a LATIN column.
  • A value of 2 specifies a UNICODE column.

Sets the character set of the column.

setDisplayLength(int)

public void setDisplayLength(int  len)
Parameter Name Description
len The length of a variable-length data type column.

Sets the length of a variable-length data type column. You can use this method for CHARACTER, VARCHAR, CLOB, VARBYTE, and BLOB types.

setJsonFormat(byte)

public void setJsonFormat(byte  p)

Sets the JSON storage format of a JSON column.

setPeriodType(int)

public void setPeriodType(int  ptype)
Sets the Period type of the column. Valid values are as follows:
NOT_PERIOD = 0
    PERIOD_DATE = 1
    PERIOD_TIME = 2
    PERIOD_TIME_WTZ =3
    PERIOD_TIMESTAMP = 4
    PERIOD_TIMESTAMP_WTZ = 5

setPrecision(int)

public void setPrecision(int  prec)
Parameter Name Description
prec The precision for the DECIMAL column.

Sets the precision for a DECIMAL column.

setScale(int)

public void setScale(int  Scale)
Parameter Name Description
Scale The scale for the DECIMAL column.

Sets the scale for a DECIMAL column.

setTimeZone(boolean)

public void setTimeZone(boolean  isWTZ)
Parameter Name Description
isWTZ The time zone for the column.

Sets the time zone of a TIME or DATE type column.

setUDTName(String)

public void setUDTName(String  name)

Sets the UDT name of the output column.

Inherited Methods

The following methods are inherited from class java.lang.Object:
  • equals
  • getClass
  • hashCode
  • notify
  • notifyAll
  • toString
  • wait, wait, wait