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.