home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
sp15demo.zip
/
libsrc.zip
/
LIBSRC
/
SQLCODES.PAS
< prev
next >
Wrap
Pascal/Delphi Source File
|
1996-02-22
|
19KB
|
261 lines
UNIT SQLCODES;
{**************************************************************************
* *
* Module Name = SQLCODES.H *
* *
* Descriptive Name = External Include file for SQLCODES *
* *
* Copyright = 5622-044 (C) Copyright IBM Corp. 1988, 1993 *
* Licensed Material - Program Property of IBM *
* Refer to Copyright Instructions Form Number G120-3083 *
* *
* Function = Include File defining *
* SQLCODES *
* *
**************************************************************************}
INTERFACE
USES OS2Def;
CONST
/* SQL Return Codes in SQLCODE */
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_E013 = -13 ; /* cursor or statement name = "" */
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 */
IMPLEMENTATION
END.