Posted: Sun Jan 22, 2006 11:09 pm Post subject: logging/printing inside ESQL
Newbie
Joined: 22 Jan 2006 Posts: 2
I am working on ESQL and i am trying to explore if it’s possible to do logging/printing inside ESQL. It would be similar to System.out.println () in java OR Print statements in SQL.Could anyone please help out.
If it is before V6 then you cannot log or print directly, but you can use the Environment Tree / LocalEnvironment tree to store data and then use a trace ndoe downstream to display it, or THROW an exception which will be written to the event log.
Or, from V5 CSD4 and onwards you can CALL a Java Procedure that wrote to a file.
Or in V6 you have a LOG statement that will log to the Event / Syslog depending on platform.
There are probably a few other ways as well, but these are the main one I can think of of the top of my head.
Regards, _________________ MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum