Re: SQLIDEBUG and sqliprint

--0__=88BBE417DFFF13A18f9e8a93df938690918c88BBE417DFFF13A1 Content-type: multipart/alternative; Boundary="1__=88BBE417DFFF13A18f9e8a93df938690918c88BBE417DFFF13A1" --1__=88BBE417DFFF13A18f9e8a93df938690918c88BBE417DFFF13A1 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Yes its true ... but if you want the same with JDBC ..you will have to = do the following in your java program: String url =3D "jdbc:Informix- sqli//<ip_address>:informixserver=3Dxxx;user=3D<username>;password=3D<p= assword>;PROTOCOLTRACE=3D2;PROTOCOLTRACEFILE=3D/tmp/raj/raj"; This will generate SQLIDEBUG output for you and then you can use sqlipr= int to read the output. Unfortunately, you cannot make it dynamic for Java programs AFAIK. Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = "rkusenet" = <rkusenet@sympati = co.ca> = To Sent by: informix-list@iiug.org = owner-informix-li = cc st@iiug.org = Subj= ect Re: SQLIDEBUG and sqliprint = 04/28/2004 09:36 = AM = = = Please respond to = "rkusenet" = = = "rkusenet" <rkusenet@sympatico.ca> wrote in message news:c6oc0d$eahps$1@ID-75254.news.uni-berlin.de... > I need to trace every sql of a session for debugging purpose. Reading= > c.d.i archives it looks like SQLIDEBUG and sqlprint is a good option.= > > I believe this is how sqlidebug starts > > export SQLIDEBUG=3D2:/tmp/sqllog > export SQLIDEBUG looks like SQLIDEBUG can not be used with java/jdbc. It is only for 'C'. The ids version we are using is 9.21.UC4. Is this true? = --1__=88BBE417DFFF13A18f9e8a93df938690918c88BBE417DFFF13A1 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Yes its true ... but if you want the same with JDBC ..you will have = to do the following in your java program:<br> <br> <font face=3D"Arial">String url =3D &quot;jdbc:Informix-<br> sqli//&lt;ip_address&gt;:informixserver=3Dxxx;user=3D&lt;username&gt;;p= assword=3D&lt;password&gt;;PROTOCOLTRACE=3D2;PROTOCOLTRACEFILE=3D/tmp/r= aj/raj&quot;;<br> <br> This will generate SQLIDEBUG output for you and then you can use sqlipr= int to read the output.</font><br> <br> <font face=3D"Arial">Unfortunately, you cannot make it dynamic for Java= programs AFAIK.</font><br> <br> Thanx much,<br> <br> Rajib Sarkar<br> Advisory Software Engineer (RAS)<br> IBM Data Management Group <br> <br> If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison<br> <br> <img src=3D"cid:10__=3D88BBE417DFFF13A18f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for &quot;rkusenet&quot= ; &lt;rkusenet@sympatico.ca&gt;">&quot;rkusenet&quot; &lt;rkusenet@symp= atico.ca&gt;<br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE41= 7DFFF13A18f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">&quot;rkusenet&quot; &lt;rkusenet@sympatico.ca&= gt;</font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> <p><font size=3D"2">04/28/2004 09:36 AM</font> <table border=3D"1"> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= center"><font size=3D"2">Please respond to<br> &quot;rkusenet&quot;</font></div></td></tr> </table> </ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE417DFFF13A18f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE417DFFF13A18f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">informix-list@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE417DFFF13A18f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE417DFFF13A18f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE417DFFF13A18f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D88BBE417DFFF13A18f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">Re: SQLIDEBUG and sqliprint</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE417DFFF= 13A18f9e8a93df938@us.ibm.com"