Oninit cdi / Archive
Talk to an expert →

To Print last executed SQL Query

Posted in 2006

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

SRIDHAR RAMAKRISHNAN — — source: IIUG Forums & Mailing Lists

Hi, Is it possible to print the last SQL query that failed in an application. I haved 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 queries including their 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
Clifton Bean — — source: IIUG Forums & Mailing Lists

Research onmode -Y in the Administrator's Guide. Take care. Clifton -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of SRIDHAR RAMAKRISHNAN Sent: Thursday, August 24, 2006 5:51 PM To: ids@iiug.org Subject: To Print last executed SQL Query [7343] Hi, Is it possible to print the last SQL query that failed in an application. I haved 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 queries including their values instead of placeholders like "?" Can anyone please throw some light on the same. Any short example would be more helpful. Cheers, Sridhar **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary