Preprocessing and postprocessing SQL statements

For any component with database connectivity, you can enter preprocessing and postprocessing SQL statements in the Property window of the components. Those properties allow you to enter SQL statements that are executed during initialization (preprocessing) of the component or after completion (postprocessing) of the project.

Some considerations:

• The SQL statements do not return output after execution.

• Any SQL statement accepted by the connected database system is allowed.

• You can enter multiple SQL statements in the preprocessing or postprocessing SQL property by using a semicolon; as a statement delimiter.

• SBN expressions are allowed in preprocessing and postprocessing SQL.

These examples show preprocessing and postprocessing SQL:

delete from products;
update customers 
set cu_desc = 'valid';