Correcting invalid SQL syntax

A DECLARE LOCAL TEMPORARY TABLE statement in a procedure or trigger causes a syntax error if the table name is prefixed with an owner name.

Remove the owner name.

If a CREATE TRIGGER statement does not include an owner name for the table on which the trigger is defined, and the table must be qualified with an owner when referenced by the user executing the reload.sql file, the statement fails with a “Table ‘table–name’ not found” error.

Prefix the table name with the owner name.

If an object name (such as a table, column, variable or parameter name) corresponds to a reserved word introduced in a later version of Sybase IQ or SQL Anywhere (such as NCHAR), then the reload fails. (For reserved words, see the Sybase IQ Reference Manual and SQL Anywhere Server SQL Reference.) For example:

CREATE PROCEDURE p( )
BEGIN
DECLARE NCHAR INT;
SET NCHAR = 1;
END

Change all references to the reserved word to use a different name. For variable names, prefixing the name with @ is a common convention that prevents naming conflicts.

Views that use Transact–SQL™ outer joins (by specifying *= or =*) may not be created properly when they are reloaded.

Add the following line to the reload script:

SET TEMPORARY OPTION
tsql_outer_joins='on'

and also set this option for your database.You should later rewrite any views or Stored Procedures that use Transact–SQL outer joins.

Stored procedures that use Transact–SQL outer joins may not work correctly.

Rewrite views and stored procedures.

Functions that have OUT or INOUT parameters cannot be reloaded.

OUT and INOUT parameters are no longer supported. The functions must be dropped before doing a reload.