To Print last executed SQL Query

Posted in 2006

Topics: SQL Development & Query Writing, Versions, Editions & End-of-Life

SRIDHAR RAMAKRISHNAN — Thu, 24 Aug 2006 22:51:22 — source: IIUG Forums & Mailing Lists

Hi, Is it possible to print the last SQL query that failed in an application. I have heard that it is possible in IDS 9.4. We can print the ISAM messages using the rgetmsg but I am interested to print the entire SQL query including the values instead of placeholders like "?" Can anyone please throw some light on the same. Any short example would be more helpful. Cheers, Sridhar

↪ replying to SRIDHAR RAMAKRISHNAN

lupasa@sisa.com.bo — Thu, 24 Aug 2006 22:58:47 — source: IIUG Forums & Mailing Lists

Hi, You could use first onstat -u and find the session Id of= the running process on Informix. Then onstat -g sql [session id]= You will see the error numbers for SQL and ISAM= , and the last sql statements Luis Panozzo Saavedra= Gerente T=E9cnico Soluciones Integrales S= .A. Calle Ignacio Cordero 976, Ed. Te= rranova, Piso 2, Of. 207 Tel=E9fonos y&nb= sp;Fax: +591 2 2773378 +591 2 2794538 La Paz - Bolivia =

Related threads

Glossary

IDS (Informix Dynamic Server)