SQL Templates window allows you to paste into the SQL Editor predefined SQL and SPL statements. You can also create your own custom script templates and use them when writing the code in SQL Editor. For example, it can be standard company copyright statement or procedure comments block. It also can be standard error processing code or any other frequently used statements, such as ONSTAT, ONMODE or any other IBM Informix utilities.
The SQL Templates window is opened using Paste SQL popup menu from the SQL Editor panel.
To paste the template statement into the current cursor position of the SQL Editor, select the statement in the list from SQL, SPL or Custom tabs and press Paste button.
To modify any template statement, select this statement in the list and press Edit button.
To delete any template statement, select this statement in the list and press Delete button.
To create new template statement, select this statement in the list and press Add button. The template statement will be created in the currently active tab - SQL, SPL or Custom.