The following limitations apply to replicating user-defined routines (UDRs) from a primary database in Dynamic Server 2000:
UDRs written in an external language, such as C or Java, cannot be replicated because the Replication Agent cannot access external UDR source. To be replicated, a UDR must be written in SPL (stored procedure language).
When searching the primary database for the UDR named in a pdb_setrepproc proc, mark command, the Replication Agent searches for a UDR with the specific name of proc or with the actual name of proc (and if owner is specified, owner.proc), using it in the where clause. If no UDR is found, or if more than one UDR is found, the specified UDR cannot be marked for replication as a stored procedure.
If the specific-name search succeeds and no replicate name was supplied in the pdb_setrepproc command, the replicate name will be the actual UDR name.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
