JDBC Receiver - SQL Sentence Log.

[Former Member]

Hi.

I have one scenario Proxy to JDBC , now is working well.

One of my technical user , told me if there any option to see the SQL Stament generated to JDBC driver.

Is there any option on PI to see the SQL like? :   Update Table1 Set Field1 = 'XXXXX' , Field2 = 'SASDASD' Where Field3 > 1000

On Communication Channel Monitoring , Message Display - Message  Content - Payload , only I see a String like.

Table1XXXXXSASDAS1000

I use Protocol XML SQL Format. - Update Stament.

http://help.sap.com/saphelp_nw73/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Regards.

Thiago

[baskar_gopalakrishnan2 · Accepted solution]

Set logSQLStatement = true in the advance mode of the jdbc communication channel. You will the sql log.

refer this link..

http://saptechnical.com/Tips/XI/SQL/Log.htm

[Former Member · Accepted solution]

Thank you.

Regards