Intelligent Templates

Intelligent templates are available for SQL Anywhere and Sybase IQ user-defined functions.

Intelligent templates are provided for executing user-defined functions. Two templates are available:
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.

Parent topic: Database Development

Send your feedback on this help topic to Sybase Technical Publications: pubs@sybase.com

Your comments will be sent to the technical publications staff at Sybase, Inc. For product-related issues or technical support, contact Sybase Technical Support at 1-800-8SYBASE.