Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


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

Code Block
languagejavascript
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;