Creating a New Template

Select Window > Preferences.

In the left pane, select Sybase, Inc. and expand Database Development.

Expand SQL Editor and choose Templates to display a list of templates in the right pane.

Click New.

In the Name field, enter a name for the template.

The name is used for selecting templates from the content assist options list. Duplicate template names are allowed. Use the description or context to distinguish duplicate template names.

From the Context drop-down menu, select the most appropriate option.

Select	If the template is to be used for
Data Federation	Only for Data Federation code
SQL	All SQL code
SQL Anywhere	Only for SQL Anywhere SQL code
SQL-ASE	Only for ASE SQL code
SQL-IQ	Only for Sybase IQ SQL code
SQL-ASE15	Only for ASE 15 SQL code
Replication Server	Only for Replication Server SQL code

(Optional) In the Description field, enter a description of the template.

The description displays after the template name in content assist. This description differentiates templates with the same name.

In the Pattern field, enter the template text pattern.

The pattern can include predefined and custom template variables.

(Optional) Select Insert Variable to display a list of predefined variables, and then select the variable you want to insert and double-click its name.

Variables are placeholders that allow you to enter different values each time you apply the template. Before a template is inserted into SQL Editor, variables in its pattern are evaluated, and its placeholders are replaced with evaluated values. Variables are of the form ${apply the template variable_name}.

The variable appears in the Pattern field.

(Optional) Create your own template variable by using ${variableName}, which evaluates to the name of the variable itself.

Make sure that the name does not conflict with the name of any predefined template variable. If the dollar symbol appears as a literal, it must be escaped by using a second dollar sign or by using the variable ${dollar}.

Click OK.