Replication Server 15.5 supports the Adaptive Server 15.5 deferred name resolution feature. Deferred name resolution lets you create stored procedures in Adaptive Server without resolving the objects used internally by these stored procedures.
Adaptive Server postpones the object resolution phase until you first execute the stored procedure in Adaptive Server. Stored procedures execute normally when you execute them after the first time. See “Deferred Name Resolution for User-Defined Stored Procedures” in the Adaptive Server Enterprise 15.5 New Features Summary.
In Replication Server versions earlier than 15.5, you can set up a warm standby application and enable sp_reptostandby at the active database to allow replication of supported data definition language (DDL) commands to the standby database.
However, on a standby database or a replicate database in a non-warm standby environment, you cannot create a stored procedure that references a temporary table, because Replication Server does not replicate temporary tables. The create stored procedure process must resolve the objects used internally by the stored procedure. However, there is no temporary table in the replicate or standby database, therefore, Replicate Server does not create the stored procedure in the replicate or standby database.
With support for deferred name resolution, Replication Server 15.5 allows the replication of stored procedures that refer to temporary tables, tables that do not exist, and procedures that do not exist, to replicate or standby databases.
See “Deferred name resolution,” in Chapter 5, “Managing RepAgent and Supporting Adaptive Server” in the Replication Server Administration Guide Volume 1 to configure deferred name resolution in Replication Server.