You can view a log of the SQL query that the Integration Service passes to the database for processing. When you set logging to verbose, the Integration Service writes each SQL query to the session log. Set logging to verbose when you need to debug a session with the SQL transformation.
If the query contains CLOB or BLOB data, the session log contains does not contain the query. The session log contains a message that describes the data, such as CLOB Data.