Not able to View generated SQL statement

[Former Member]

Hi,

In order to view the generated SQL statement in Receiver JDBC Adapter,

i have done logSQLStatement as true in CC still not able to view in RWB,

also mesg protocol i m using in CC is "xml sql format", is it bcos of this i am not able to ?

If yes, then how can i see that sql string?

Regards,

Pratibha

[Former Member · Accepted solution]

Pratibha,

In CC, check if the parameter has any extra spaces (may be in the end) and press a enter after entering the value true. Make sure therea re no extra spaces any where in the parameter and the value.

I assume you are in SP09 or above.

Regards,

Jai Shankar

[Former Member · Accepted solution]

ya great its done..

thanks,

thats wat i was doubting of, that actually my logSql true setting isnt working at all,

thanks

[Former Member]

Pratibha,

In our JDBC scenario the message protocol is also set to XML SQL Format

The Integration Process has a mapping step of type XSL that uses an Imported Archive to create the SQL select statement. Then there is a synchronous Send step for the JDBC component

Both this SQL statement and the returned SQL result are available in the XML message monitor SXMB_MONI

Regards,

Mike