Reference Guide
>
TDV SQL Script
>
SQL Script Examples
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)