NzaeDataTypes Class reference

This class contains constant int values corresponding to the Netezza database column data types.

This class contains constant int values corresponding to the Netezza database column data types. These values are identical to data type values used in the Netezza UDX API.

See also: getDataTypes, getDataTypes

Static public attributes

NZUDSUDX_BOOL
Boolean data type.
NZUDSUDX_DATE
Date data type.
NZUDSUDX_DOUBLE
Double data type.
NZUDSUDX_FIXED
Fixed string data type.
NZUDSUDX_FLOAT
Float data type
NZUDSUDX_GEOMETRY
Geometry data type.
NZUDSUDX_INT16
Int16 data type.
NZUDSUDX_INT32
Int32 data type.
NZUDSUDX_INT64
Int64 data type.
NZUDSUDX_INT8
Int8 data type.
NZUDSUDX_INTERVAL
Interval data type.
NZUDSUDX_MAX_TYPE
Max data type.
NZUDSUDX_NATIONAL_FIXED
National fixed string data type.
NZUDSUDX_NATIONAL_VARIABLE
National variable data type.
NZUDSUDX_NUMERIC128
Numeric128 data type.
NZUDSUDX_NUMERIC32
Numeric32 data type.
NZUDSUDX_NUMERIC64
Numeric64 data type.
NZUDSUDX_TIME
Time data type.
NZUDSUDX_TIMESTAMP
Timestamp data type.
NZUDSUDX_TIMETZ
Timetz data type.
NZUDSUDX_UNKNOWN
Unknown data type.
NZUDSUDX_VARBINARY
VarBinary data type.
NZUDSUDX_VARIABLE
Variable string data type.

Static public member functions

static String javaTypeToString(int t)
Returns a String representation of a Java data type from java.sql.Types.
static String nzTypeToString(int t)
Returns a String resprsentation of an NZ data type.

Static member data documentation

final int NZUDSUDX_BOOL= 4
Boolean data type.
final int NZUDSUDX_DATE= 5
Date data type.
final int NZUDSUDX_DOUBLE= 12
Double data type.
final int NZUDSUDX_FIXED= 0
Fixed string data type.
final int NZUDSUDX_FLOAT= 11
Float data type
final int NZUDSUDX_GEOMETRY= 19
Geometry data type.
final int NZUDSUDX_INT16= 15
Int16 data type.
final int NZUDSUDX_INT32= 16
Int32 data type.
final int NZUDSUDX_INT64= 17
Int64 data type.
final int NZUDSUDX_INT8= 14
Int8 data type.
final int NZUDSUDX_INTERVAL= 13
Interval data type.
final int NZUDSUDX_MAX_TYPE= 21
Max data type.
final int NZUDSUDX_NATIONAL_FIXED= 2
National fixed string data type.
final int NZUDSUDX_NATIONAL_VARIABLE= 3
National variable data type.
final int NZUDSUDX_NUMERIC128= 10
Numeric128 data type.
final int NZUDSUDX_NUMERIC32= 8
Numeric32 data type.
final int NZUDSUDX_NUMERIC64= 9
Numeric64 data type.
final int NZUDSUDX_TIME= 6
Time data type.
final int NZUDSUDX_TIMESTAMP= 18
Timestamp data type.
final int NZUDSUDX_TIMETZ= 7
Timetz data type.
final int NZUDSUDX_UNKNOWN= -1
Unknown data type.
final int NZUDSUDX_VARBINARY= 20
VarBinary data type.
final int NZUDSUDX_VARIABLE= 1
Variable string data type.

Static public member functions documentation

static String javaTypeToString(int t)
Returns a String representation of a Java data type from java.sql.Types.
Parameters
  • t

    The java.sql.Types type number.

Returns

The string representation of the java type.

static String nzTypeToString(int t)
Returns a String resprsentation of an NZ data type.
Parameters
  • t

    The number type.

Returns

The string representation of the type.