Scripts

A SQL script consists of one or more SQL statements not returning any data. For example, there are properties allowing you to execute SQL statements during initialization (pre-processing) of a component or after completion (post-processing) of the project.

Some considerations:

• SQL statements must not return output after execution.

• You can enter multiple SQL statements in a SQL property by using a semicolon as a statement delimiter.

• When using stored procedures in a SQL property, include the call keyword before the stored procedure name. For example, call my_proc(); where my_proc() is the name of the stored procedure.

Example of a SQL script:

DELETE FROM products;
UPDATE customers 
SET cu_desc = 'valid';