Error Informix
Contents |
then you are in trouble. This site was put together to help informix error codes our engineers when they need to quickly check an error code and don't have command line access to a server. The error codes detailed are those from the 10 IDS
Informix Error Messages
install CD. So some errors are missing, the Optical subsystem breakdown for example. If you want these included you will need to email over the relevant msg file a and they will be processed and included. The list of contents is based on an old 7.20 manual and some cross-referencing by ourselves, there doesn't appear to be cross reference for the error numbers any more. If you know where there is one please let us know. Need this on your PDA then try www.oninit.com/
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us informix sql error Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community informix odbc error Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Informix ERROR:
Informix Error 951
A syntax error has occurred. Error Code: -201 up vote 1 down vote favorite The only statement in my SQL code is DEFINE p_starttime DATETIME YEAR TO SECOND; I get this error from Informix 10.5: ERROR: A syntax error has occurred. Error http://www.oninit.com/errorcode/ Code: -201 Query = DEFINE p_starttime DATETIME YEAR TO SECOND Anybody has a clue why this might be happening? It's such a simple statement. informix share|improve this question asked Jun 28 '12 at 18:50 Baris Seker 9818 You need to explain what you are trying to do. You can only define variables in the context of a stored procedure. You need to explain which language or program you are using to access the database. The CREATE FUNCTION statement might have failed for many different http://stackoverflow.com/questions/11251060/informix-error-a-syntax-error-has-occurred-error-code-201 reasons. (Also, as a matter of interest, there never was a version 10.5 of Informix; the versions went 9.40, 10.00, 11.10, 11.50, 11.70. Which version of what are you using, on which platform?) –Jonathan Leffler Jun 29 '12 at 16:34 add a comment| 1 Answer 1 active oldest votes up vote 2 down vote It's not valid SQL, as simple as that. DEFINE is not a keyword you can use in a query. It is part of the Stored Procedure Language, or SPL syntax, ie: CREATE FUNCTION foo(); DEFINE p_starttime DATETIME YEAR TO SECOND; -- do stuff RETURN p_starttime; END FUNCTION; share|improve this answer answered Jun 28 '12 at 21:35 RET 7,80212027 This gives an error too: ERROR: A syntax error has occurred. Error Code: -201 Query = CREATE FUNCTION foo() –Baris Seker Jun 29 '12 at 7:26 Sorry, that was never meant to be a runnable stored procedure. I didn't have access to an Informix instance when I wrote it. It probably should say CREATE FUNCTION foo() RETURNING DATETIME YEAR TO SECOND; .... The salient point is that DEFINE cannot be used in SQL. –RET Jun 30 '12 at 7:45 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the an
syntax: Connector {ERROR|WARNING} (Number): Message Informix error and warning messages have the following syntax: Informix {ERROR|WARNING|NO DATA} (SQLSTATE: sqlstate): Message SQLCODE http://unifaceinfo.com/docs/0907/Uniface_Library_HTML/ulibrary/INF_ERROR_MESSAGES_8D2EBF82035239ACC427446CB1D50115.html sqlcode: Message The last error detected by the connector is available in $dberror. The possible error messages are listed in the table. Table 1. Error values returned in $dberror $dberror value Message 0 Success, no error. <0 Error detected by Informix. 20 The requested function/mode is not supported. 21 The specified database environment name is too long. 22 The connector can informix error fetch by primary key only. 23 No more cursors could be allocated. 24 No more statements could be allocated. 25 Connector deleted/updated more or less than 1 row. 26 The parsed SQL statement was not a select. 27 An illegal request was received by the connector. 28 Already logged on to a database. 29 Unrecognized option for open database. 30 informix error codes No database environment name was specified. 31 Maximum number of logons exceeded. 32 Bad option found in USYS$INF_PARAMS. 33 Bad option value found in USYS$INF_PARAMS. 34 Mutual exclusive options found in USYS$INF_PARAMS. 35 Can’t execute next step. Cursor has been released. 36 Initialization of segmented field in Uniface Virtual Memory failed. 37 Data row size too large. 38 Selection of BLOBs not supported. 39 Data type of existing field does not match BLOB type. 40 Procedure manager raised a DBMS error. 41 CreateProc: The procedure list is not initialized. 42 AllocProcList: Allocation of the procedure list has failed. 43 SetParamPtrs: The parameter value pointers could not be set. 44 Maximum number of connections per logon exceeded. 45 No database name was specified. 46 The database name specified is too long. 47 The specified server name is too long. 48 The specified user name is too long. 49 The specified password name is too long. 50 Sql command buffer overflow. 51 Selected engine does not match specified engine in USYS$INF_PARAMS. 52 Overflow tables cannot be created on the fly. 53 Allocation