Re: Getting Line Number Error in a query

Posted in 2005

Claus Samuelsen — Thu, 03 Feb 2005 22:26:34 +0100 — source: Usenet: comp.databases.informix

Jose J. Sanchez wrote: > How can i get the line number or position of a syntax error when i execute a query > > lets say for example: > > SELECT * > FROM nonexistent_table > WHERE id = 1> > i have an error on line 2, > > is there a way to get this information from informix?? If you're using ESQL/C you can check the sqlca structure. sqlca.sqlerrd[4] will contain the position of where an error was detected, when sqlca.sqlcode = 201.