Using a SQL Definition Set
You can reference a SQL definition set and all of the data types defined in the definition set from SQL scripts, stored procedures, XQuery procedures, and XSLT procedures.
The procedure described here refers to the data types defined in a SQL definition set named mySQLDef:
Name | Base Type |
firstname | CHAR(255) |
lastname | CHAR(255) |
To use an SQL-type definition set
1. Create a SQL script.
2. Reference the SQL definition set in the PROCEDURE using the TDV resource path and name.
The SQL script below uses the SQL definition set named mySQLDef.
3. Execute the script to see the result.
