How to examine the generated SQL statement in Receiver JDBC Adapter

[Former Member]

I have been searching this forum how to display te generated sql statement (by the jdbc receiver adapter).

The only suggestion is to use RWB, but I was unable to find any details about how to do so.

Any help is appreciated

[Former Member · Accepted solution]

Use the parameter

logSQLStatement true

in your receiver JDBC comm channel. Click on Advanced properties and enter this parameter with value true.

Now in RWB, CC monitoring you can see the generated SQL.

Regards,

Jai Shankar

[Former Member · Accepted solution]

Hi,

To add, u can see the SQL Statements in Audit log of RWB.

Select Message Monitoring-> Adapter Engine. choose ur entry and click on Details option button, u can see the SQL Statements in Audit Log.

Regards,

Sudharshan

Message was edited by:

Sudharshan Aravamudan

[Former Member]

Hi,

Also see the below link

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards

Chilla..

[prabhu_s2]

by checking the logSQLStatement as true in the JDBC adapter (receiver CC) the generated SQL can be viewed in the RWB (source: CC monitoring)

[Former Member]

Hi,

Please see the below link

http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

from above link

Additional parameters are published in SAP Note 801367

Regards

Chilla..

[bhavesh_kantilal]

Hi,

In your receiver JDBC adapter you need to have an option called LogSQL and then you can see the Query in the Audit Log on the Adapter in RWB.

This is discusses in the note : 801367

Regards

Bhavesh