As a Process Developer, you may want to view the SQL statement(s) and parameter values used to write to a database. It's important to note that for DB SQL parameters, viewing the complete SQL statement only works for writes and not reads. You can, however, view the incoming parameters within the Process log.
The following solution will review how to accomplish this.
Within the Connection component, there’s an Advanced Options tab. It’s from this tab that we can choose to export the sql file to disk.
If the ‘Write SQL To File?’ option is checked, the actual writing of data to the DB is NOT performed. If you wish to both write the data to the DB and also export the sql file to disk, you can insert a Branch step and have one path using this Advanced Options feature (writing the sql file to disk) and have the other path writing the data to the DB.
Take note that the file was successfully exported to the SQL File Path.