! ******************************************************************************************************************************** ! Created: 17-May-2011 10:41:55 by OpenVMS SDL EV2-3 ! Source: 17-MAY-2011 10:41:55 SQL$ALPHA_MV:[CODE]SQL_LITERALS.SDL;1 ! ******************************************************************************************************************************** ! Copyright (c) 1995, 2011, Oracle Corporation. All Rights Reserved. !*** MODULE SQLCA_DEFINITIONS *** !DEC$ OPTIONS/ALIGN=(RECORDS=PACKED,COMMONS=PACKED)/NOWARN ! ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ! ! S Q L C A . S D L Defines the SQL communications area ! ! ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ! ! FACILITY: Rdb/SQL ! ! ABSTRACT: ! ! AUTHOR: R.ADAMS CREATION DATE: 17-FEB-1986. ! MODIFICATION HISTORY: ! ! Version 7.2 ! 5-Jan-11 05683 (IES) new SQLCODE and SQLSTATE values ! 27-Apr-09 05529 (IES) add new SQLDA_ROWID type ! 10-Feb-09 05496 (IES) use ASCII copyright notation ! 7-Jun-07 05311 (NJL) Correct last edit. ! 7-Jun-07 05310 (JEH) Add invalid substring SQLCODE and SQLSTATE ! Version 7.0 ! 16-Jan-96 02697 (PMB) Change copyright as necessary ! 23-FEB-1986 rga define literals for values of SQLCODE ! ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ! ! Define values for SQLDA.SQLVAR.SQLTYPE ! PARAMETER SQLDA_VARCHAR = '000001C1'X PARAMETER SQLDA_CHAR = '000001C5'X ! The SQLDA_ constants have PARAMETER SQLDA_ROWID = '000001C7'X ! values corresponding to PARAMETER SQLDA_FLOAT = '000001E1'X ! the value placed in PARAMETER SQLDA_DECIMAL = '000001E5'X ! SQLDA.SQLVAR.SQLTYPE by SQL. PARAMETER SQLDA_INTEGER = '000001F1'X ! They represent the data type PARAMETER SQLDA_SMALLINT = '000001F5'X ! of the select list item or PARAMETER SQLDA_DATE = '000001F7'X ! parameter marker. PARAMETER SQLDA_QUADWORD = '000001F9'X PARAMETER SQLDA_ASCIZ = '000001FB'X PARAMETER SQLDA_SEGSTRING = '000001FD'X PARAMETER SQLDA_TINYINT = '00000203'X PARAMETER SQLDA_VARBYTE = '00000204'X PARAMETER SQLDA2_DATETIME = '00000207'X PARAMETER SQLDA2_INTERVAL = '00000209'X PARAMETER SQLDA_SURROGATE = '00000258'X ! Reserved for future use ! ! Define values for datetime subtypes from DBL X4.5. DO NOT CHANGE THEM EVER. ! PARAMETER SQLDA2_DT_DATE = '00000001'X PARAMETER SQLDA2_DT_TIME = '00000002'X PARAMETER SQLDA2_DT_TIMESTAMP = '00000003'X PARAMETER SQLDA2_DT_TIME_TZ = '00000004'X PARAMETER SQLDA2_DT_TIMESTAMP_TZ = '00000005'X ! ! Define values for interval subtypes from DBL X4.5. DO NOT CHANGE THEM EVER. ! PARAMETER SQLDA2_DT_YEAR = '00000001'X PARAMETER SQLDA2_DT_MONTH = '00000002'X PARAMETER SQLDA2_DT_DAY = '00000003'X PARAMETER SQLDA2_DT_HOUR = '00000004'X PARAMETER SQLDA2_DT_MINUTE = '00000005'X PARAMETER SQLDA2_DT_SECOND = '00000006'X PARAMETER SQLDA2_DT_YEAR_MONTH = '00000007'X PARAMETER SQLDA2_DT_DAY_HOUR = '00000008'X PARAMETER SQLDA2_DT_DAY_MINUTE = '00000009'X PARAMETER SQLDA2_DT_DAY_SECOND = '0000000A'X PARAMETER SQLDA2_DT_HOUR_MINUTE = '0000000B'X PARAMETER SQLDA2_DT_HOUR_SECOND = '0000000C'X PARAMETER SQLDA2_DT_MINUTE_SECOND = '0000000D'X ! ! Define values for SQLCODE ! PARAMETER SQL$K_SQLCODE_OFFSET = '0000000C'X ! Offset to sqlcode ! ! success status ! PARAMETER SQLCODE_SUCCESS = '00000000'X ! command completed successfully ! ! Warning statuses ! PARAMETER SQLCODE_EOS = '00000064'X ! SELECT or cursor got to end of stream PARAMETER SQLCODE_ELIM_NULL = '000003EB'X ! Null value eliminated in set function PARAMETER SQLCODE_TRUN_RTRV = '000003EC'X ! String truncated during assignment to a variable or p ! String truncated during assignment to a variable or paramet ! ! Error statuses ! PARAMETER SQLCODE_RDBERR = -1 ! Rdb returned an error ! -2 TO -1000 are used for DB2 compatible errors PARAMETER SQLCODE_OUTOFRAN = -304 ! Value is out of range for a host variable PARAMETER SQLCODE_NULLNOIND = -305 ! NULL value and no indicator variable" PARAMETER SQLCODE_STR_DAT_TRUNC = -306 ! String data, right truncation PARAMETER SQLCODE_INV_DATETIME = -307 ! Invalid datetime format PARAMETER SQLCODE_CURNOTOPE = -501 ! Cursor isn't open PARAMETER SQLCODE_CURALROPE = -502 ! Cursor is already open PARAMETER SQLCODE_UDCURNOPE = -507 ! Cursor in update or delete isn't opened PARAMETER SQLCODE_UDCURNPOS = -508 ! Cursor in update or delete is not positioned on a record PARAMETER SQLCODE_UDCURDEL = -509 ! Cursor in update or delete, positioned on a deleted record PARAMETER SQLCODE_NO_DUP = -803 ! Duplicate on index PARAMETER SQLCODE_SELMORVAL = -811 ! THE RESULT OF AN EMBEDDED SELECT RETURNED MORE THAN 1 VALUE PARAMETER SQLCODE_ROTXN = -817 ! Read write operation in R-O txn PARAMETER SQLCODE_SVPTINVSPEC = -880 ! Savepoint is invalid */ PARAMETER SQLCODE_SVPTEXIST = -881 ! Savepoint already exists */ PARAMETER SQLCODE_SVPTNOEXIST = -882 ! Savepoint does not exists */ PARAMETER SQLCODE_DEADLOCK = -913 ! deadlock encountered ! -1001 to -1999 are reserved for DEC specific SQLCODEs PARAMETER SQLCODE_INTEG_FAIL = -1001 ! Constraint failed PARAMETER SQLCODE_NOT_VALID = -1002 ! Valid-if failed PARAMETER SQLCODE_LOCK_CONFLICT = -1003 ! Lock conflict PARAMETER SQLCODE_BAD_TXN_STATE = -1004 ! Invalid transaction state PARAMETER SQLCODE_NO_TXN = -1005 ! No transaction PARAMETER SQLCODE_BAD_VERSION = -1006 ! version of base system doesn't PARAMETER SQLCODE_TRIG_ERROR = -1007 ! Trigger forced an error PARAMETER SQLCODE_NOIMPTXN = -1008 ! No implicit transaction. PARAMETER SQLCODE_DISTIDERR = -1009 ! Distrubuted TID Error. PARAMETER SQLCODE_BAD_CTX_VER = -1010 ! Bad version in context struct PARAMETER SQLCODE_BAD_CTX_TYPE = -1011 ! Bad type in context struct PARAMETER SQLCODE_BAD_CTX_LEN = -1012 ! Bad length in context struct PARAMETER SQLCODE_BASROWDEL = -1013 ! Row containing list deleted. PARAMETER SQLCODE_DIFFDEFINV = -1014 ! Invoker was not the definer. PARAMETER SQLCODE_STMTNOTPRE = -1015 ! Dynamic statement not prepared PARAMETER SQLCODE_NOSUCHCONN = -1016 ! Connection doesn't exist PARAMETER SQLCODE_CONNAMEXI = -1017 ! Connection name already exists PARAMETER SQLCODE_DBENVSYNERR = -1018 ! Database Environment syntax errror PARAMETER SQLCODE_DBSPECSYNERR = -1019 ! Database spec syntax error PARAMETER SQLCODE_ATTACHERR = -1020 ! Error attaching to database PARAMETER SQLCODE_NOSUCHALIAS = -1021 ! Alias not known PARAMETER SQLCODE_ALIASINUSE = -1022 ! Alias already declared PARAMETER SQLCODE_COLEXISTS = -1023 ! Column already exists in Table PARAMETER SQLCODE_COLNOTDEF = -1024 ! Column not defined in Table PARAMETER SQLCODE_TBLEXISTS = -1025 ! Table already exists in database PARAMETER SQLCODE_DOMEXISTS = -1026 ! Domain already exists in database PARAMETER SQLCODE_DOMNOTDEF = -1027 ! Domain not defined in database PARAMETER SQLCODE_NO_PRIV = -1028 ! No privilege for attempted operation PARAMETER SQLCODE_BAD_LENGTH = -1029 ! Negative length specified for column PARAMETER SQLCODE_BAD_SCALE = -1030 ! Negative scale specified for column PARAMETER SQLCODE_RO_TABLE = -1031 ! Attempt to update a RO table PARAMETER SQLCODE_OBSMETADATA = -1032 ! Metadata no longer available PARAMETER SQLCODE_UNRES_REL = -1033 ! Relation in req not reserved in trans PARAMETER SQLCODE_CASENOTFND = -1034 ! Case not found: no WHEN for selector PARAMETER SQLCODE_CHKOPT_VIOL = -1035 ! Integ failure w/ check option PARAMETER SQLCODE_UNTERM_C_STR = -1036 ! Unterminated C string PARAMETER SQLCODE_INDIC_OVFLOW = -1037 ! Indicator overflow PARAMETER SQLCODE_INV_PARAM_VAL = -1038 ! Invalid parameter value PARAMETER SQLCODE_NULL_ELIMIN = -1039 ! Null eliminated in set function PARAMETER SQLCODE_INV_ESC_SEQ = -1040 ! Invalid escape sequence PARAMETER SQLCODE_RELNOTDEF = -1041 ! Table not defined in database PARAMETER SQLCODE_RELNOTDCL = -1041 ! Table not defined in database PARAMETER SQLCODE_SIGNAL_SQLSTATE = -1042 ! SQLSTATE signaled PARAMETER SQLCODE_NORETSTMT = -1043 ! no return statement PARAMETER SQLCODE_INVSUBSTRLEN = -1044 ! Invalid substring length ! -2000 to -2999 are reserved for use by SQL Server ! -20000 to -20999 reserved to DB2 compatible errors PARAMETER SQLCODE_SVPTBADLOC = -20111 ! Cannot use SAVEPOINT from function or trigger */ !DEC$ END OPTIONS