SQL Script Examples

This section contains several examples illustrating the use of the SQL Script language. All the examples assume a user named test in the domain composite.

Example 1 (Fetch All Rows)
Example 2 (Fetch All Categories)
Example 3 (User-Defined Type)
Example 4 (User-Defined Type)
Example 5 (Pipe Variable)
Example 6 (Dynamic SQL Extract with Individual Inserts)
Example 7 (Dynamic SQL Inserts by Variable Name)
Example 8 (Prepackaged Query)
Example 9 (Exception Handling)
Example 10 (Row Declaration)
Example 11 (Avoiding Division-by-Zero Errors)