In one of the previous recipes, we saw how we can print the input and select query for debugging. This recipe shows how this can be achieved for an update, delete, or insert, which are all functions available through
Open the job
jo_cook_ch07_0050_printOutputSQL, which is a copy of the job from the previous recipe.
The steps to be performed are as follows:
tJavaRowand link it to
tMysqlOutputcomponent and click on the Advanced settings tab.