SQL Constants



The following is a list of available Profound.js SQL global constants:

SQL_DEFAULT = 99; SQL_CHAR = 1; SQL_NUMERIC = 2; SQL_DECIMAL = 3; SQL_INTEGER = 4; SQL_SMALLINT = 5; SQL_FLOAT = 6; SQL_REAL = 7; SQL_DOUBLE = 8; SQL_DATETIME = 9; SQL_VARCHAR = 12; SQL_BLOB = 13; SQL_CLOB = 14; SQL_DBCLOB = 15; SQL_DATALINK = 16; SQL_WCHAR = 17; SQL_WVARCHAR = 18; SQL_BIGINT = 19; SQL_BLOB_LOCATOR = 20; SQL_CLOB_LOCATOR = 21; SQL_DBCLOB_LOCATOR = 22; SQL_UTF8_CHAR = 23; SQL_WLONGVARCHAR = SQL_WVARCHAR; SQL_LONGVARCHAR = SQL_VARCHAR; SQL_GRAPHIC = 95; SQL_VARGRAPHIC = 96; SQL_LONGVARGRAPHIC = SQL_VARGRAPHIC; SQL_BINARY = -2; SQL_VARBINARY = -3; SQL_LONGVARBINARY = SQL_VARBINARY; SQL_DATE = 91; SQL_TYPE_DATE = 91; SQL_TIME = 92; SQL_TYPE_TIME = 92; SQL_TIMESTAMP = 93; SQL_TYPE_TIMESTAMP = 93; SQL_CODE_DATE = 1; SQL_CODE_TIME = 2; SQL_CODE_TIMESTAMP = 3; SQL_ALL_TYPES = 0; SQL_DECFLOAT = -360; SQL_XML = -370; SQL_FETCH_NEXT = 1; SQL_FETCH_FIRST = 2; SQL_FETCH_LAST = 3; SQL_FETCH_PRIOR = 4; SQL_FETCH_ABSOLUTE = 5; SQL_FETCH_RELATIVE = 6; SQL_PARAM_INPUT = 1; SQL_PARAM_OUTPUT = 2; SQL_PARAM_INPUT_OUTPUT = 3; /* Valid environment attributes */ SQL_ATTR_OUTPUT_NTS = 10001; SQL_ATTR_SYS_NAMING = 10002; SQL_ATTR_DEFAULT_LIB = 10003; SQL_ATTR_SERVER_MODE = 10004; SQL_ATTR_JOB_SORT_SEQUENCE = 10005; SQL_ATTR_ENVHNDL_COUNTER = 10009; SQL_ATTR_ESCAPE_CHAR = 10010; SQL_ATTR_INCLUDE_NULL_IN_LEN = 10031; SQL_ATTR_UTF8 = 10032; SQL_ATTR_SYSCAP = 10033; SQL_ATTR_REQUIRE_PROFILE = 10034; SQL_ATTR_UCS2 = 10035; SQL_ATTR_TRUNCATION_RTNC = 10036; SQL_ATTR_DATE_FMT = 10020; SQL_ATTR_DATE_SEP = 10021; SQL_ATTR_TIME_FMT = 10022; SQL_ATTR_TIME_SEP = 10023; SQL_ATTR_DECIMAL_SEP = 10024; SQL_ATTR_TXN_INFO = 10025; SQL_ATTR_TXN_EXTERNAL = 10026; SQL_ATTR_2ND_LEVEL_TEXT = 10027; SQL_ATTR_SAVEPOINT_NAME = 10028; SQL_ATTR_TRACE = 10029; SQL_ATTR_MAX_PRECISION = 10040; SQL_ATTR_MAX_SCALE = 10041; SQL_ATTR_MIN_DIVIDE_SCALE = 10042; SQL_ATTR_HEX_LITERALS = 10043; SQL_ATTR_CORRELATOR = 10044; SQL_ATTR_QUERY_OPTIMIZE_GOAL = 10045; SQL_ATTR_CONN_SORT_SEQUENCE = 10046; SQL_ATTR_PREFETCH = 10100; SQL_ATTR_CLOSEONEOF = 10101; SQL_ATTR_ANSI_APP = 10102; SQL_ATTR_INFO_USERID = 10103; SQL_ATTR_INFO_WRKSTNNAME = 10104; SQL_ATTR_INFO_APPLNAME = 10105; SQL_ATTR_INFO_ACCTSTR = 10106; SQL_ATTR_INFO_PROGRAMID = 10107; SQL_ATTR_DECFLOAT_ROUNDING_MODE = 10112; SQL_ATTR_OLD_MTADTA_BEHAVIOR = 10113; SQL_ATTR_NULL_REQUIRED = 10114; SQL_ATTR_FREE_LOCATORS = 10115; SQL_ATTR_EXTENDED_INDICATORS = 10116; SQL_ATTR_NULLT_ARRAY_RESULTS = 10117; SQL_ATTR_NULLT_OUTPUT_PARMS = 10118; SQL_ATTR_TIMESTAMP_PREC = 10119; SQL_ATTR_CONCURRENT_ACCESS_RESOLUTION = 2595; SQL_ATTR_APP_ROW_DESC = 10010; SQL_ATTR_APP_PARAM_DESC = 10011; SQL_ATTR_IMP_ROW_DESC = 10012; SQL_ATTR_IMP_PARAM_DESC = 10013; SQL_ATTR_FOR_FETCH_ONLY = 10014; SQL_ATTR_CONCURRENCY = 10014; SQL_ATTR_CURSOR_SCROLLABLE = 10015; SQL_ATTR_ROWSET_SIZE = 10016; SQL_ATTR_ROW_ARRAY_SIZE = 10016; SQL_ATTR_CURSOR_HOLD = 10017; SQL_ATTR_FULL_OPEN = 10018; SQL_ATTR_EXTENDED_COL_INFO = 10019; SQL_ATTR_BIND_TYPE = 10049; SQL_ATTR_CURSOR_TYPE = 10050; SQL_ATTR_CURSOR_SENSITIVITY = 10051; SQL_ATTR_ROW_STATUS_PTR = 10052; SQL_ATTR_ROWS_FETCHED_PTR = 10053; SQL_ATTR_ROW_BIND_TYPE = 10056; SQL_ATTR_PARAMSET_SIZE = 10058; SQL_ATTR_PARAM_STATUS_PTR = 10059; SQL_ATTR_PARAMS_PROCESSED_PTR = 10060; SQL_ATTR_NUMBER_RESULTSET_ROWS_PTR = 10061; SQL_ATTR_AUTO_IPD = 10001; SQL_ATTR_ACCESS_MODE = 10002; SQL_ATTR_AUTOCOMMIT = 10003; SQL_ATTR_DBC_SYS_NAMING = 10004; SQL_ATTR_DBC_DEFAULT_LIB = 10005; SQL_ATTR_ADOPT_OWNER_AUTH = 10006; SQL_ATTR_SYSBAS_CMT = 10007; SQL_ATTR_SET_SSA = 10008; SQL_ATTR_COMMIT = 0; SQL_ATTR_TXN_ISOLATION = 0; SQL_TXN_NO_COMMIT = 1; SQL_FALSE = 0; SQL_TRUE = 1; SQL_NTS = 3; SQL_BIND_BY_ROW = 0; SQL_BIND_BY_COLUMN = 1; SQL_CURSOR_FORWARD_ONLY = 0; SQL_CURSOR_STATIC = 1; SQL_CURSOR_DYNAMIC = 2; SQL_CURSOR_KEYSET_DRIVEN = 3; SQL_UNSPECIFIED = 0; SQL_INSENSITIVE = 1; SQL_SENSITIVE = 2; SQL_FMT_ISO = 1; SQL_FMT_USA = 2; SQL_FMT_EUR = 3; SQL_FMT_JIS = 4; SQL_FMT_MDY = 5; SQL_FMT_DMY = 6; SQL_FMT_YMD = 7; SQL_FMT_JUL = 8; SQL_FMT_HMS = 9; SQL_FMT_JOB = 10; SQL_SEP_SLASH = 1; SQL_SEP_DASH = 2; SQL_SEP_PERIOD = 3; SQL_SEP_COMMA = 4; SQL_SEP_BLANK = 5; SQL_SEP_COLON = 6; SQL_SEP_JOB = 7; SQL_NULL_DATA = -1;   SQL_MAX_ROWSET_SIZE = 32767; SQL_FETCH_ALL = -1;