dbinfo('sqlca.sqlerrd1') stopped working
Poster found dbinfo('sqlca.sqlerrd1') (used to fetch the last inserted SERIAL value) suddenly returning 0 on IDS 9.40; restarting the server and dropping/recreating the table didn't help. Suggestions were to check whether the column was SERIAL8 (needing dbinfo('serial8')) and whether it was still a SERIAL — both confirmed fine. The value worked again the next day in WinSql but still failed from the application. No resolution is recorded; the advice was to open a case with IBM/Informix support.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
I have been using the dbinfo('sqlca.sqlerrd1') function to obtain last insert ID for a while, and all of a sudden it started returning 0 all the time. This is on a development environment's database, so I restarted the DB server, and dropped and recreated the table that I use the function on. All this did not fix the problem. Does anyone else have any ideas? The IDS version is 9.40 Thanks in advance for any light shed on this problem.
Hi Peter, Are you using serial8? If yes, then use dbinfo('serial8') HTH Hrvoje -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of PETER GEYFMAN Sent: Wednesday, January 16, 2008 3:21 PM To: ids@iiug.org Subject: dbinfo('sqlca.sqlerrd1') stopped working [10930] I have been using the dbinfo('sqlca.sqlerrd1') function to obtain last insert ID for a while, and all of a sudden it started returning 0 all the time. This is on a development environment's database, so I restarted the DB server, and dropped and recreated the table that I use the function on. All this did not fix the problem. Does anyone else have any ideas? The IDS version is 9.40 Thanks in advance for any light shed on this problem. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum. See you at the IIUG Informix 2008 Conference The Power Conference for Informix Professionals April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas http://www.iiug.org/conf Registration Now Open!!
PETER GEYFMAN wrote: > I have been using the dbinfo('sqlca.sqlerrd1') function to obtain last insert > ID for a while, and all of a sudden it started returning 0 all the time. This > is on a development environment's database, so I restarted the DB server, and > dropped and recreated the table that I use the function on. All this did not > fix the problem. Does anyone else have any ideas? The IDS version is 9.40 > > Thanks in advance for any light shed on this problem. > Is the column still a SERIAL? -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
Ok, here is an update: The column is a SERIAL, and remains that after the recreate. this problem occurred yesterday, yet today it miraculously fixed itself! Now I have no idea what happened between last night and this morning to make it alright again
UPDATE2: it only works in WinSql. When running the app that uses the function it doesn't work still
PETER GEYFMAN wrote: > Ok, here is an update: > Time to open a case with IBM/Informix tech support. Art S. Kagel Oninit > The column is a SERIAL, and remains that after the recreate. > this problem occurred yesterday, yet today it miraculously fixed itself! > Now I have no idea what happened between last night and this morning to make > it alright again ================================================================================ =========== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ================================================================================ ===========