Review the reload script (reload.sql) for legacy syntax that can cause iqunload to fail.
Problem |
Solution |
---|---|
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–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
SAP Sybase IQ, the reload fails. (For
reserved words, see Reference: Building
Blocks, Tables, and Procedures. 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'Also set this option for your database. 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. Drop these functions before reloading. |