home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
PRECOM.ZIP
/
SQLCODES.DEF
< prev
next >
Wrap
Text File
|
1992-09-09
|
15KB
|
269 lines
DEFINITION MODULE SQLCodes;
(*# call(o_a_size => off,
o_a_copy=>off,
result_optional=>on,
reg_saved => (si, di, ds, st1, st2),
reg_param => (),
seg_name => none,
near_call => off,
ds_eq_ss => off) *)
(*# module(implementation=>off, init_code => off) *)
(*# name(prefix => os2_lib) *)
(*# data(near_ptr => off,var_enum_size=>off) *)
(*# check(index=>off,range=>off,overflow=>off,nil_ptr=>off) *)
(**************************************************************************
Module Name = SQLCODES.H
Descriptive Name = SQLCODEs External Include File
Copyright = nnnnnnnn (C) Copyright IBM Corp. 1987, 1990
Licensed Material - Program Property of IBM
Refer to Copyright Instructions Form Number G120-3083
Function = Include File defining SQLCODEs
Operating System = OS/2 Extended Edition
**************************************************************************)
(* SQL Return Codes in SQLCODE *)
CONST
SQL_RC_OK = 0; (* successful execution *)
(* ------------ warnings ------------ *)
SQL_RC_W012 = 12; (* correlation without qualification *)
SQL_RC_W100 = 100; (* eof *)
SQL_RC_W139 = 139; (* duplicate column conistraint *)
SQL_RC_W143 = 143; (* invalid syntax ignored *)
SQL_RC_W541 = 541; (* duplicate referential constraint *)
SQL_RC_W605 = 605; (* index already exists *)
SQL_RC_W965 = 965; (* unknown SQL warning another product*)
(* ------------- errors ------------- *)
SQL_RC_E007 = -7; (* illegal character *)
SQL_RC_E010 = -10; (* string constant not terminated *)
SQL_RC_E051 = -51; (* reserved *)
SQL_RC_E084 = -84; (* bad sql statement *)
SQL_RC_E101 = -101; (* statement too long *)
SQL_RC_E102 = -102; (* string constant too long *)
SQL_RC_E103 = -103; (* invalid numeric literal *)
SQL_RC_E104 = -104; (* invalid character/token *)
SQL_RC_E105 = -105; (* invalid string constant *)
SQL_RC_E107 = -107; (* name too long *)
SQL_RC_E108 = -108; (* name has too many qualifiers *)
SQL_RC_E109 = -109; (* clause not permitted *)
SQL_RC_E111 = -111; (* no column name *)
SQL_RC_E112 = -112; (* operand is sql function *)
SQL_RC_E117 = -117; (* wrong nbr of insert values *)
SQL_RC_E118 = -118; (* object table in from clause *)
SQL_RC_E119 = -119; (* column not in group by *)
SQL_RC_E120 = -120; (* clause includes sql fn *)
SQL_RC_E121 = -121; (* dup column name *)
SQL_RC_E122 = -122; (* no group by *)
SQL_RC_E125 = -125; (* no result column *)
SQL_RC_E127 = -127; (* dup distinct *)
SQL_RC_E129 = -129; (* too many table names *)
SQL_RC_E131 = -131; (* incompatible data for like *)
SQL_RC_E132 = -132; (* like predicate invalid *)
SQL_RC_E134 = -134; (* improper use of long string *)
SQL_RC_E138 = -138; (* substr arg out of range *)
SQL_RC_E142 = -142; (* syntax not supported *)
SQL_RC_E150 = -150; (* view not updatable *)
SQL_RC_E151 = -151; (* column not updatable *)
SQL_RC_E153 = -153; (* no column list *)
SQL_RC_E156 = -156; (* command not allowed on view *)
SQL_RC_E157 = -157; (* view name in foreign key *)
SQL_RC_E158 = -158; (* nbr of columns does not match *)
SQL_RC_E159 = -159; (* drop view on table *)
SQL_RC_E160 = -160; (* with check not allowed on view *)
SQL_RC_E161 = -161; (* with check violation *)
SQL_RC_E170 = -170; (* nbr of arguments invalid *)
SQL_RC_E171 = -171; (* argument invalid *)
SQL_RC_E172 = -172; (* function name invalid *)
SQL_RC_E176 = -176; (* translate scalar argument invalid *)
SQL_RC_E180 = -180; (* datetime syntax invalid *)
SQL_RC_E181 = -181; (* datetime value invalid *)
SQL_RC_E182 = -182; (* datetime arithmetic invalid *)
SQL_RC_E183 = -183; (* datetime arithmetic out of range *)
SQL_RC_E198 = -198; (* no statement text *)
SQL_RC_E199 = -199; (* illegal use of reserved word *)
(* SQL Return Codes in SQLCODE *)
SQL_RC_E203 = -203; (* ambiguous column reference *)
SQL_RC_E204 = -204; (* undefined name *)
SQL_RC_E205 = -205; (* not a column *)
SQL_RC_E206 = -206; (* not a column of referenced tables *)
SQL_RC_E207 = -207; (* cannot orderby column name w/union *)
SQL_RC_E208 = -208; (* column not part of result table *)
SQL_RC_E212 = -212; (* duplicate table designator *)
SQL_RC_E301 = -301; (* host variable has invalid type *)
SQL_RC_E302 = -302; (* host variable value too large *)
SQL_RC_E303 = -303; (* data types not comparable *)
SQL_RC_E304 = -304; (* value not in range of host var *)
SQL_RC_E305 = -305; (* host var cannot be null *)
SQL_RC_E309 = -309; (* host var should not be null *)
SQL_RC_E311 = -311; (* length of host var is negative *)
SQL_RC_E312 = -312; (* unusable host variable *)
SQL_RC_E313 = -313; (* wrong nbr of host variables *)
SQL_RC_E332 = -332; (* no conversn source-cp to target-cp *)
SQL_RC_E401 = -401; (* operands not comparable *)
SQL_RC_E402 = -402; (* invalid type for arithmetic op *)
SQL_RC_E404 = -404; (* update/insert string too long *)
SQL_RC_E405 = -405; (* numeric literal out of range *)
SQL_RC_E406 = -406; (* derived value out of range *)
SQL_RC_E407 = -407; (* column cannot be null *)
SQL_RC_E408 = -408; (* invalid data type for column *)
SQL_RC_E409 = -409; (* invalid operand for count *)
SQL_RC_E410 = -410; (* float literal too long *)
SQL_RC_E412 = -412; (* multiple columns in subquery *)
SQL_RC_E413 = -413; (* overflow during data conversion *)
SQL_RC_E415 = -415; (* incompatible data types for union *)
SQL_RC_E416 = -416; (* long string in union *)
SQL_RC_E417 = -417; (* invalid use of parameter markers *)
SQL_RC_E418 = -418; (* parameter marker in select clause *)
SQL_RC_E419 = -419; (* division produced negative scale *)
SQL_RC_E421 = -421; (* diff number of columns for union *)
SQL_RC_E436 = -436; (* C language char string missing null*)
SQL_RC_E501 = -501; (* cursor not open (fetch/close) *)
SQL_RC_E502 = -502; (* cursor already open *)
SQL_RC_E503 = -503; (* column not in update clause *)
SQL_RC_E504 = -504; (* cursor name not defined *)
SQL_RC_E507 = -507; (* cursor not open (update/delete) *)
SQL_RC_E508 = -508; (* cursor not on a row *)
SQL_RC_E509 = -509; (* table not same as for cursor *)
SQL_RC_E510 = -510; (* table cannot be modified *)
SQL_RC_E511 = -511; (* for update not allowed *)
SQL_RC_E514 = -514; (* cursor not prepared *)
SQL_RC_E516 = -516; (* describe not a prepared statement *)
SQL_RC_E517 = -517; (* prepared statment not a select *)
SQL_RC_E518 = -518; (* execute not a prepared statement *)
SQL_RC_E519 = -519; (* statement has an open cursor *)
SQL_RC_E530 = -530; (* invalid foreign key value *)
SQL_RC_E531 = -531; (* cannot update primary key *)
SQL_RC_E532 = -532; (* delete is restricted *)
SQL_RC_E533 = -533; (* multi-row insert not allowed *)
SQL_RC_E534 = -534; (* multi-row update of pk *)
SQL_RC_E535 = -535; (* multi-row delete not allowed *)
SQL_RC_E536 = -536; (* descendent in subquery *)
SQL_RC_E537 = -537; (* dup column in key def *)
SQL_RC_E538 = -538; (* foreign key does not match pk *)
SQL_RC_E539 = -539; (* table does not have primary key *)
SQL_RC_E541 = -541; (* duplicate referential constraint *)
SQL_RC_E542 = -542; (* pk column cannot allow nulls *)
SQL_RC_E551 = -551; (* authorization error w/obj insert *)
SQL_RC_E552 = -552; (* auth error w/o obj ins *)
SQL_RC_E553 = -553; (* SYSIBM qualifier *)
SQL_RC_E554 = -554; (* cannot grant privilege to self *)
SQL_RC_E555 = -555; (* cannot revoke privilege from self *)
SQL_RC_E556 = -556; (* revoke stmt denied--priv not held *)
SQL_RC_E557 = -557; (* invalid combination of privileges *)
SQL_RC_E558 = -558; (* revoke stmt denied--has CONTROL *)
SQL_RC_E562 = -562; (* privilege not allowed for public *)
SQL_RC_E567 = -567; (* invalid authorization id *)
(* SQL Return Codes in SQLCODE *)
SQL_RC_E601 = -601; (* duplicate table/view name *)
SQL_RC_E602 = -602; (* too many columns in index *)
SQL_RC_E603 = -603; (* cannot create unique index *)
SQL_RC_E604 = -604; (* invalid length, precision, scale *)
SQL_RC_E607 = -607; (* op not allowed on system tables *)
SQL_RC_E612 = -612; (* duplicate column name *)
SQL_RC_E613 = -613; (* primary key too long *)
SQL_RC_E614 = -614; (* index key too long *)
SQL_RC_E624 = -624; (* table already has primary key *)
SQL_RC_E629 = -629; (* foreign key is not nullable *)
SQL_RC_E631 = -631; (* foreign key is too long *)
SQL_RC_E632 = -632; (* delete rule restriction *)
SQL_RC_E633 = -633; (* delete rule is restricted *)
SQL_RC_E634 = -634; (* delete rule cannot be CASCADE *)
SQL_RC_E637 = -637; (* dup pk or drop pk clause *)
SQL_RC_E638 = -638; (* no column definitions *)
SQL_RC_E667 = -667; (* ref constraint does not hold *)
SQL_RC_E669 = -669; (* cannot drop primary key *)
SQL_RC_E670 = -670; (* row length too large *)
SQL_RC_E673 = -673; (* primary key not unique *)
SQL_RC_E680 = -680; (* too many columns for table *)
SQL_RC_E683 = -683; (* incompatible column constraint *)
SQL_RC_E802 = -802; (* arith overflow or divide by zero *)
SQL_RC_E803 = -803; (* distinct violation *)
SQL_RC_E804 = -804; (* bad input parameters *)
SQL_RC_E805 = -805; (* program not found *)
SQL_RC_E811 = -811; (* more than one row/value *)
SQL_RC_E818 = -818; (* time stamp conflict *)
SQL_RC_E822 = -822; (* invalid address in sqlda *)
SQL_RC_E840 = -840; (* too many items in list *)
SQL_RC_E902 = -902; (* fatal error *)
SQL_RC_E910 = -910; (* drop pending *)
SQL_RC_E911 = -911; (* deadlock *)
SQL_RC_E912 = -912; (* too many lock requests *)
SQL_RC_E920 = -920; (* reject DB connection to SA REQ *)
SQL_RC_E930 = -930; (* insufficient storage *)
SQL_RC_E950 = -950; (* cursors active on dropped object *)
SQL_RC_E951 = -951; (* table in use - alter disallowed *)
SQL_RC_E952 = -952; (* user cancel *)
SQL_RC_E953 = -953; (* agent heap too small *)
SQL_RC_E954 = -954; (* application heap too small *)
SQL_RC_E955 = -955; (* sort heap error *)
SQL_RC_E956 = -956; (* database heap too small *)
SQL_RC_E957 = -957; (* requestor comm heap too small *)
SQL_RC_E958 = -958; (* max nbr of files open *)
SQL_RC_E959 = -959; (* server comm heap too small *)
SQL_RC_E960 = -960; (* max nbr of files in database *)
SQL_RC_E961 = -961; (* rqstr remote svcs heap too small *)
SQL_RC_E962 = -962; (* svr remote svcs heap too small *)
SQL_RC_E964 = -964; (* log file full *)
SQL_RC_E966 = -966; (* error opening sqlcode mapping file *)
SQL_RC_E967 = -967; (* format error in sqlcode map file *)
SQL_RC_E968 = -968; (* disk full *)
SQL_RC_E969 = -969; (* unknown sql error another product *)
SQL_RC_E970 = -970; (* read-only file *)
SQL_RC_E972 = -972; (* incorrect diskette *)
SQL_RC_E974 = -974; (* drive locked *)
SQL_RC_E976 = -976; (* diskette door open *)
SQL_RC_E978 = -978; (* diskette write-protected *)
SQL_RC_E980 = -980; (* disk error *)
SQL_RC_E982 = -982; (* disk error on temp file *)
SQL_RC_E984 = -984; (* unsuccessful commit or rollback *)
SQL_RC_E985 = -985; (* file error - catalog file bad *)
SQL_RC_E986 = -986; (* file error - file renamed *)
SQL_RC_E990 = -990; (* index structure limit error *)
SQL_RC_E992 = -992; (* release number incompatible *)
SQL_RC_E994 = -994; (* reserved *)
SQL_RC_E996 = -996; (* reserved *)
SQL_RC_E1216 = -1216; (* invalid use of graphic data *)
SQL_RC_E30000= -30000; (* Distribution protocol error, *)
(* no disconnect *)
SQL_RC_E30020 = -30020; (* Distribution protocol error, *)
(* disconnect *)
SQL_RC_E30021 = -30021; (* Distribution compatibility error *)
SQL_RC_E30040 = -30040; (* Distribution memory allocation err *)
SQL_RC_E30041 = -30041; (* Distribution memory allocation err *)
(* disconnect *)
SQL_RC_E30050 = -30050; (* Invalid command while bind in prog *)
SQL_RC_E30051 = -30051; (* Bind not active *)
SQL_RC_E30053 = -30053; (* Bind Owner authorization failure *)
SQL_RC_E30060 = -30060; (* RDB authorization failure *)
SQL_RC_E30061 = -30061; (* RDB not found *)
SQL_RC_E30070 = -30070; (* Distribution command error *)
SQL_RC_E30071 = -30071; (* Distribution object error *)
SQL_RC_E30072 = -30072; (* Distribution parameter error *)
SQL_RC_E30073 = -30073; (* Distribution parameter value error *)
SQL_RC_E30074 = -30074; (* Distribution reply error *)
SQL_RC_E30080 = -30080; (* Communication error *)
SQL_RC_E30090 = -30090; (* Remote operation invalid *)
END SQLCodes.