Is there any way I can, from with in the program script (a BOI in this case), enable database trace options via, TT_SQL_TRACE or DBSLOG ?

I know that we can do this either through BW Config or Option Dialog - Debug bshell...

What I require is to enable this database tracing from a script (or a BOI).

You can enable Database Trace options for a BOI from JavaClient not within the BOI. Before u initialise the IBaanFactoryJava class u need to call the static debug class like this
Debug.setTraceOn(Debug.SQL_TRACE);
Debug.setTraceOn(Debug.TRACE_ALL);

Hi jayaseelan,
Thanks for the input. Could you tell me how I could get more info about IBaanFactoryJava classes?

That would be of immense help.

regards,
Srini

IBaanFactoryJava class comes with BCBE installation. But its in the binary .class format. If u have any Java decompiler, then u can decompile and see the Java source code of IBaanFactoryJava. By the way why do u need IBaanFactoryJava class? You can directly use the class as such.

Hi jayaseelan,
Can you also tell where this debug log will get stored, I have worked on BOIs with JAVA and JSP as frontend, Apache as webserver.

In the BCBE.cfg file u can specify the file name and directory where u want to store the log file. Also u can redirect this output to jsp pages.
Usually log files will be stored in the directory from where ur JavaClient is running and accessing the BOI's.

Sample BCBE.cfg file

# indicates which server to use
LoginServer=90.0.0.232

# server1 login info
90.0.0.232.Host=90.0.0.232
90.0.0.232.Port=512
90.0.0.232.User=bsp
90.0.0.232.Password=bsp
90.0.0.232.BSE=/usr5/baan4c4/bse
90.0.0.232.Bshell=bshellxma
90.0.0.232.Command=-server
90.0.0.232.BaanVersion=1
90.0.0.232.ClientLogFile=JavaClient_boi.txt
90.0.0.232.Debug=TRACE_ALL
90.0.0.232.TimeOut=0