Scripts

A SQL script consists of one or more SQL statements that do not return any data. For example, there are properties allowing you to execute SQL statements during initialization (preprocessing) of a component or after completion (postprocessing) 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.

This is an example of a SQL script:

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