[FAQ000175]How can I check the SQL statement when executing a SQL action?

Q

I have created an action set that will be executed by passing parameters to the SQL action,

but I would like to check the SQL statement that will actually be executed with the parameters reflected.

Is there any way to check the SQL statement of the SQL action that was actually executed in the debug log, etc.?

A

Although there is no function to check the actually issued SQL statement in the debug log, etc.,

if the SQL statement reflects the parameters before execution, a method to prepare a log table

for debugging and write the SQL string to be executed when calling the SQL action to the table

can be considered.