Pre-processing and post-processing SQL

For any component with database connectivity you can enter pre-processing and post-processing SQL statements in the Property section. Those properties allow entering SQL statements that are executed during initialization (pre-processing) or after completion (post-processing) of the component.

Some considerations are:

• The SQL statements will not return output after being executed.

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

• You can enter multiple SQL statement in the pre-processing or post-processing SQL property by using a semicolon; as a statement delimiter.

• SBN expressions are allowed in pre-processing and post-processing SQL.

The following examples show pre-processing and post-processing SQL:

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