4.5.5 Appendix: Definitions of Parameter Data Types

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