Intelligent templates are available for SQL Anywhere and Sybase IQ user-defined functions.
| Template | Description |
| Execute - intelligently execute a user-defined function |
With this template option, there are no variables declared for input parameters. For example:
BEGIN
DECLARE @col_name_var CHAR(128)
EXECUTE @col_name_var = col_name @object_id = value0,
@column_id = value1, @database_id = value2
END
|
| Execute - intelligently execute a user-defined function with declared variables for input parameters |
This option provides several declared variables for input parameters. For example:
BEGIN
DECLARE @col_name_var CHAR(128)
DECLARE @object_id_var INT
DECLARE @column_id_var INT
DECLARE @database_id_var INT
SELECT @object_id_var = value0
SELECT @column_id_var = value1
SELECT @database_id_var = value2
EXECUTE @col_name_var = col_name @object_id = @object_id_var ,
@column_id = @column_id_var , @database_id = @database_id_var
END
|
For additional information, see Intelligent Templates and Using Intelligent Templates in the Sybase WorkSpace online documentation.