This section provides some pointers for developing procedures. The following subjects are discussed in this topic:
Checking if you need to change he command delimiter
Remembering to delimit statements within your procedure
Using fully-qualified names for tables in procedures
Specifying dates and times in procedures
For more information on dates and times, see “Date and time data types” in Chapter 3, “SQL Data Types,”in Reference: Building Blocks, Tables, and Procedures.
Verifying procedure input arguments are passed correctly
For information on determining the destination of the MESSAGE statement output, see MESSAGE statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.
See ”Tips for writing procedures” in SQL Anywhere Server - SQL Usage.
Sybase IQ does not support triggers. Information on
triggers in the SQL Anywhere documentation can be ignored.
