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;
Some documentation pages have recently moved to a new section: Profound AppDev. If you are having trouble finding specific pages, try the documentation search capability or reach out to our Support team!