A Syntax Error Has Occurred. Sqlstate=42000 Db Error Code=-201
Contents |
from GoogleSign inHidden fieldsSearch for groups or messages
on), keywords misspelled (such as VALEUS for VALUES), keywords misused (such as SET in an INSERT statement or INTO in a subquery), keywords out of sequence (such as a condition of "value IS https://groups.google.com/d/topic/sql-workbench/nJgaxcFOqU8 NOT" instead of "NOT value IS"), or a reserved word used as an identifier. Database servers that provide full NIST compliance do not reserve any words; queries that work with these database servers might fail and http://www.oninit.com/201 return error -201 when they are used with earlier versions of IBM Informix database servers.
The cause of this error might be an attempt to use round-robin syntax with CREATE INDEX or ALTER FRAGMENT INIT on an index. You cannot use round-robin indexes. The error may also occur if an SQL statement uses double quotation marks around input strings and the environment variable DELIMIDENT is set. If DELIMIDENT is set, strings that are surrounded by double quotation marks are regarded as SQL identifiers rather than string literals. For more information on the usage of DELIMIDENT, see the IBM Informix Guide to SQL: Reference.be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start http://www.dbforums.com/showthread.php?1670743-Loading-Informix-from-Windows-text-file viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Loading Informix from Windows text file Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-11-11,15:24 #1 tale103108 View Profile View Forum Posts Registered User Join Date Apr 2011 Posts informix sql 7 Unanswered: Loading Informix from Windows text file I need to know the complete syntax for the LOAD command on Informix when used with a Windows file. In particular, I need the full pathname of the data file when used with the LOAD command. I have LOAD FROM 'C:\My directory\My data\mytable.unl' INSERT INTO mytable; but I get a syntax error [Error Code: -201, SQL State: 42000] A a syntax error syntax error has occurred. ---- Environment ---- O/S: WindowsXP 32-bit DB : Informix (IDS) 11.70.TC3DE JDBC: 3.50.JC9 ---- Cheers! Reply With Quote 10-13-11,15:09 #2 CheeseConQueso View Profile View Forum Posts Registered User Join Date Oct 2011 Posts 1 loading into informix try it without quotes around the path? double quotes instead of single quotes around path? if you can, change file location to somewhere without spaces in path directory - like c:\temp and try again also, i think the data HAS to be delimited with the pipe char - "|" Reply With Quote 10-14-11,09:08 #3 mjldba View Profile View Forum Posts Registered User Join Date Dec 2003 Location North America Posts 146 Piping symbol "|" is the default delimiter but I always state that explicitely in the UNLOAD and LOAD statements just to be sure. I work in an AIX environment and I don't think quotes, single or otherwise, are required for the LOAD / UNLOAD file name or path but (again) I've always used double quotes out of habit just to be sure. Reply With Quote 10-14-11,14:13 #4 douglawry View Profile View Forum Posts Visit Homepage Registered User Join Date Feb 2011 Location London Posts 6 LOAD is not a