Below are values of the parameter data types in stored procedures:
– public final static byte DT_DEFAULT = (byte) 0; |
//default value, auto-identification |
– public final static byte DT_INT = (byte) 1; |
//a 32-bit integer |
– public final static byte DT_LONG = (byte) 2; |
//a 64-bit long integer |
– public final static byte DT_SHORT = (byte) 3; |
//a 16-bit short integer |
– public final static byte DT_BIGINT = (byte) 4; |
//a big integer |
– public final static byte DT_FLOAT = (byte) 5; |
//a 32-bit floating point |
– public final static byte DT_DOUBLE = (byte) 6; |
//a 64-bit double-precision floating point |
– public final static byte DT_DECIMAL = (byte) 7; |
//a big decimal |
– public final static byte DT_DATE = (byte) 8; |
//date |
– public final static byte DT_TIME = (byte) 9; |
//time |
– public final static byte DT_DATETIME = (byte) 10; |
//datetime |
– public final static byte DT_STRING = (byte) 11; |
//string |
– public final static byte DT_BOOLEAN = (byte) 12; |
//boolean |
|
|
– public final static byte DT_INT_SERIES = (byte) 51; |
//a sequence of integers |
– public final static byte DT_LONG_SERIES = (byte) 52; |
//a sequence of long integers |
– public final static byte DT_SHORT_SERIES = (byte) 53; |
// a sequence of short integers |
– public final static byte DT_BIGINT_SERIES = (byte) 54; |
//a sequence of big integers |
– public final static byte DT_FLOAT_SERIES = (byte) 55; |
//a sequence of floating points |
– public final static byte DT_DOUBLE_SERIES = (byte) 56; |
//a sequence of double-precision floating points |
– public final static byte DT_DECIMAL_SERIES = (byte) 57; |
//a sequence of big decimals |
– public final static byte DT_DATE_SERIES = (byte) 58; |
//a sequence of dates |
– public final static byte DT_TIME_SERIES = (byte) 59; |
// a sequence of time values |
– public final static byte DT_DATETIME_SERIES = (byte) 60; |
//a sequence of datetime values |
– public final static byte DT_STRING_SERIES = (byte) 61; |
//a string sequence |
– public final static byte DT_BYTE_SERIES = (byte) 62; |
//a sequence of bytes |
|
|
– public final static byte DT_CURSOR = (byte) 101; |
//cursor |
– public final static byte DT_AUTOINCREMENT = (byte) 102; |
//self-increment field |