odbcdef.java

picoSQL is a SQL-based, multi-user, client/server RDBMS, released under the GPL

    public static final int SQL_FN_NUM_DEGREES = 0x40000;
    public static final int SQL_FN_NUM_LOG10 = 0x80000;
    public static final int SQL_FN_NUM_POWER = 0x100000;
    public static final int SQL_FN_NUM_RADIANS = 0x200000;
    public static final int SQL_FN_NUM_ROUND = 0x400000;
    public static final int SQL_FN_NUM_TRUNCATE = 0x800000;
    public static final short SQL_STRING_FUNCTIONS = 50;
    public static final int SQL_FN_STR_CONCAT = 1;
    public static final int SQL_FN_STR_INSERT = 2;
    public static final int SQL_FN_STR_LEFT = 4;
    public static final int SQL_FN_STR_LTRIM = 8;
    public static final int SQL_FN_STR_LENGTH = 16;
    public static final int SQL_FN_STR_LOCATE = 32;
    public static final int SQL_FN_STR_LCASE = 64;
    public static final int SQL_FN_STR_REPEAT = 128;
    public static final int SQL_FN_STR_REPLACE = 256;
    public static final int SQL_FN_STR_RIGHT = 512;
    public static final int SQL_FN_STR_RTRIM = 1024;
    public static final int SQL_FN_STR_SUBSTRING = 2048;
    public static final int SQL_FN_STR_UCASE = 4096;
    public static final int SQL_FN_STR_ASCII = 8192;
    public static final int SQL_FN_STR_CHAR = 16384;
    public static final int SQL_FN_STR_DIFFERENCE = 32768;
    public static final int SQL_FN_STR_LOCATE_2 = 0x10000;
    public static final int SQL_FN_STR_SOUNDEX = 0x20000;
    public static final int SQL_FN_STR_SPACE = 0x40000;
    public static final short SQL_SYSTEM_FUNCTIONS = 51;
    public static final int SQL_FN_SYS_USERNAME = 1;
    public static final int SQL_FN_SYS_DBNAME = 2;
    public static final int SQL_FN_SYS_IFNULL = 4;
    public static final short SQL_TIMEDATE_FUNCTIONS = 52;
    public static final int SQL_FN_TD_NOW = 1;
    public static final int SQL_FN_TD_CURDATE = 2;
    public static final int SQL_FN_TD_DAYOFMONTH = 4;
    public static final int SQL_FN_TD_DAYOFWEEK = 8;
    public static final int SQL_FN_TD_DAYOFYEAR = 16;
    public static final int SQL_FN_TD_MONTH = 32;
    public static final int SQL_FN_TD_QUARTER = 64;
    public static final int SQL_FN_TD_WEEK = 128;
    public static final int SQL_FN_TD_YEAR = 256;
    public static final int SQL_FN_TD_CURTIME = 512;
    public static final int SQL_FN_TD_HOUR = 1024;
    public static final int SQL_FN_TD_MINUTE = 2048;
    public static final int SQL_FN_TD_SECOND = 4096;
    public static final int SQL_FN_TD_TIMESTAMPADD = 8192;
    public static final int SQL_FN_TD_TIMESTAMPDIFF = 16384;
    public static final int SQL_FN_TD_DAYNAME = 32768;
    public static final int SQL_FN_TD_MONTHNAME = 0x10000;
    public static final short SQL_CONVERT_BIGINT = 53;
    public static final short SQL_CONVERT_BINARY = 54;
    public static final short SQL_CONVERT_BIT = 55;
    public static final short SQL_CONVERT_CHAR = 56;
    public static final short SQL_CONVERT_DATE = 57;
    public static final short SQL_CONVERT_DECIMAL = 58;
    public static final short SQL_CONVERT_DOUBLE = 59;
    public static final short SQL_CONVERT_FLOAT = 60;
    public static final short SQL_CONVERT_INTEGER = 61;
    public static final short SQL_CONVERT_LONGVARCHAR = 62;
    public static final short SQL_CONVERT_NUMERIC = 63;
    public static final short SQL_CONVERT_REAL = 64;
    public static final short SQL_CONVERT_SMALLINT = 65;
    public static final short SQL_CONVERT_TIME = 66;
    public static final short SQL_CONVERT_TIMESTAMP = 67;
    public static final short SQL_CONVERT_TINYINT = 68;
    public static final short SQL_CONVERT_VARBINARY = 69;
    public static final short SQL_CONVERT_VARCHAR = 70;
    public static final short SQL_CONVERT_LONGVARBINARY = 71;
    public static final int SQL_CVT_CHAR = 1;
    public static final int SQL_CVT_NUMERIC = 2;
    public static final int SQL_CVT_DECIMAL = 4;
    public static final int SQL_CVT_INTEGER = 8;
    public static final int SQL_CVT_SMALLINT = 16;
    public static final int SQL_CVT_FLOAT = 32;
    public static final int SQL_CVT_REAL = 64;
    public static final int SQL_CVT_DOUBLE = 128;
    public static final int SQL_CVT_VARCHAR = 256;
    public static final int SQL_CVT_LONGVARCHAR = 512;
    public static final int SQL_CVT_BINARY = 1024;
    public static final int SQL_CVT_VARBINARY = 2048;
    public static final int SQL_CVT_BIT = 4096;
    public static final int SQL_CVT_TINYINT = 8192;
    public static final int SQL_CVT_BIGINT = 16384;
    public static final int SQL_CVT_DATE = 32768;
    public static final int SQL_CVT_TIME = 0x10000;
    public static final int SQL_CVT_TIMESTAMP = 0x20000;
    public static final int SQL_CVT_LONGVARBINARY = 0x40000;
    public static final short SQL_TXN_ISOLATION_OPTION = 72;
    public static final int SQL_TXN_READ_UNCOMMITTED = 1;
    public static final int SQL_TXN_READ_COMMITTED = 2;
    public static final int SQL_TXN_REPEATABLE_READ = 4;
    public static final int SQL_TXN_SERIALIZABLE = 8;
    public static final int SQL_TXN_VERSIONING = 16;
    public static final short SQL_CORRELATION_NAME = 74;
    public static final short SQL_CN_NONE = 0;
    public static final short SQL_CN_DIFFERENT = 1;
    public static final short SQL_CN_ANY = 2;
    public static final short SQL_ODBC_SQL_OPT_IEF = 73;
    public static final short SQL_NON_NULLABLE_COLUMNS = 75;
    public static final short SQL_NNC_NULL = 0;
    public static final short SQL_NNC_NON_NULL = 1;
    public static final short SQL_POSITIONED_STATEMENTS = 80;
    public static final int SQL_PS_POSITIONED_DELETE = 1;
    public static final int SQL_PS_POSITIONED_UPDATE = 2;
    public static final int SQL_PS_SELECT_FOR_UPDATE = 4;
    public static final short SQL_FILE_USAGE = 84;
    public static final short SQL_FILE_NOT_SUPPORTED = 0;
    public static final short SQL_FILE_TABLE = 1;
    public static final short SQL_FILE_QUALIFIER = 2;
    public static final short SQL_NULL_COLLATION = 85;
    public static final short SQL_NC_HIGH = 0;
    public static final short SQL_NC_LOW = 1;
    public static final short SQL_NC_START = 2;
    public static final short SQL_NC_END = 4;
    public static final short SQL_ALTER_TABLE = 86;
    public static final int SQL_AT_ADD_COLUMN = 1;
    public static final int SQL_AT_DROP_COLUMN = 2;
    public static final short SQL_COLUMN_ALIAS = 87;
    public static final short SQL_GROUP_BY = 88;
    public static final short SQL_GB_NOT_SUPPORTED = 0;
    public static final short SQL_GB_GROUP_BY_EQUALS_SELECT = 1;
    public static final short SQL_GB_GROUP_BY_CONTAINS_SELECT = 2;
    public static final short SQL_GB_NO_RELATION = 3;
    public static final short SQL_KEYWORDS = 89;
    public static final short SQL_ORDER_BY_COLUMNS_IN_SELECT = 90;
    public static final short SQL_OWNER_USAGE = 91;
    public static final int SQL_OU_DML_STATEMENTS = 1;
    public static final int SQL_OU_PROCEDURE_INVOCATION = 2;
    public static final int SQL_OU_TABLE_DEFINITION = 4;
    public static final int SQL_OU_INDEX_DEFINITION = 8;
    public static final int SQL_OU_PRIVILEGE_DEFINITION = 16;
    public static final short SQL_QUALIFIER_USAGE = 92;
    public static final int SQL_QU_DML_STATEMENTS = 1;
    public static final int SQL_QU_PROCEDURE_INVOCATION = 2;
    public static final int SQL_QU_TABLE_DEFINITION = 4;
    public static final int SQL_QU_INDEX_DEFINITION = 8;
    public static final int SQL_QU_PRIVILEGE_DEFINITION = 16;
    public static final short SQL_QUOTED_IDENTIFIER_CASE = 93;
    public static final short SQL_SPECIAL_CHARACTERS = 94;
    public static final short SQL_SUBQUERIES = 95;
    public static final int SQL_SQ_COMPARISON = 1;
    public static final int SQL_SQ_EXISTS = 2;
    public static final int SQL_SQ_IN = 4;
    public static final int SQL_SQ_QUANTIFIED = 8;
    public static final int SQL_SQ_CORRELATED_SUBQUERIES = 16;
    public static final short SQL_UNION = 96;
    public static final int SQL_U_UNION = 1;
    public static final int SQL_U_UNION_ALL = 2;
    public static final short SQL_MAX_COLUMNS_IN_GROUP_BY = 97;
    public static final short SQL_MAX_COLUMNS_IN_INDEX = 98;
    public static final short SQL_MAX_COLUMNS_IN_ORDER_BY = 99;
    public static final short SQL_MAX_COLUMNS_IN_SELECT = 100;
    public static final short SQL_MAX_COLUMNS_IN_TABLE = 101;
    public static final short SQL_MAX_INDEX_SIZE = 102;
    public static final short SQL_MAX_ROW_SIZE_INCLUDES_LONG = 103;
    public static final short SQL_MAX_ROW_SIZE = 104;
    public static final short SQL_MAX_STATEMENT_LEN = 105;
    public static final short SQL_MAX_TABLES_IN_SELECT = 106;
    public static final short SQL_MAX_USER_NAME_LEN = 107;
    public static final short SQL_MAX_CHAR_LITERAL_LEN = 108;
    public static final short SQL_MAX_BINARY_LITERAL_LEN = 112;
    public static final short SQL_LIKE_ESCAPE_CLAUSE = 113;
    public static final short SQL_QUALIFIER_LOCATION = 114;
    public static final short SQL_QL_START = 1;
    public static final short SQL_QL_END = 2;
    public static final short SQL_COLUMN_NAME = 1;
    public static final short SQL_COLUMN_TYPE = 2;
    public static final short SQL_COLUMN_LENGTH = 3;
    public static final short SQL_COLUMN_PRECISION = 4;
    public static final short SQL_COLUMN_SCALE = 5;
    public static final short SQL_COLUMN_DISPLAY_SIZE = 6;
    public static final short SQL_COLUMN_NULLABLE = 7;
    public static final short SQL_NO_NULLS = 0;
    public static final short SQL_NULLABLE = 1;
    public static final short SQL_INDEX_UNIQUE = 0;
    public static final short SQL_INDEX_ALL = 1;
    public static final short SQL_QUICK = 0;
    public static final short SQL_ENSURE = 1;
    public static final short SQL_COLUMN_UNSIGNED = 8;
    public static final short SQL_COLUMN_MONEY = 9;
    public static final short SQL_COLUMN_UPDATABLE = 10;
    public static final short SQL_ATTR_READONLY = 0;
    public static final short SQL_ATTR_WRITE = 1;
    public static final short SQL_ATTR_READWRITE_UNKNOWN = 2;
    public static final short SQL_COLUMN_AUTO_INCREMENT = 11;
    public static final short SQL_COLUMN_CASE_SENSITIVE = 12;
    public static final short SQL_COLUMN_SEARCHABLE = 13;
    public static final short SQL_UNSEARCHABLE = 0;
    public static final short SQL_SEARCHABLE = 3;
    public static final short SQL_COLUMN_TYPE_NAME = 14;
    public static final short SQL_COLUMN_TABLE_NAME = 15;
    public static final short SQL_COLUMN_OWNER_NAME = 16;
    public static final short SQL_COLUMN_QUALIFIER_NAME = 17;
    public static final short SQL_COLUMN_LABEL = 18;
    public static final short SQL_QUERY_TIMEOUT = 0;
    public static final short SQL_MAX_ROWS = 1;
    public static final short SQL_NOSCAN = 2;
    public static final int SQL_NOSCAN_OFF = 0;
    public static final int SQL_NOSCAN_ON = 1;
    public static final short SQL_MAX_LENGTH = 3;
    public static final short SQL_CONCURRENCY = 7;
    public static final int SQL_CONCUR_READ_ONLY = 1;
    public static final int SQL_CONCUR_LOCK = 2;
    public static final int SQL_CONCUR_ROWVER = 3;
    public static final int SQL_CONCUR_VALUES = 4;
    public static final short SQL_GET_BOOKMARK = 13;
    public static final short SQL_ROW_NUMBER = 14;
    public static final short SQL_BEST_ROWID = 1;
    public static final short SQL_ROWVER = 2;
    public static final short SQL_ALL_TYPES = 0;
    public static final short SQL_COMMIT = 0;
    public static final short SQL_ROLLBACK = 1;
    public static final short SQL_PARAM_TYPE_UNKNOWN = 0;
    public static final short SQL_PARAM_INPUT = 1;
    public static final short SQL_PARAM_INPUT_OUTPUT = 2;
    public static final short SQL_RESULT_COL = 3;
    public static final short SQL_PARAM_OUTPUT = 4;
    public static final short SQL_RETURN_VALUE = 5;
}