To mark a UDR for replication, the Replication Agent must be able to distinguish between the routine header and the routine body.
In versions of the Informix Dynamic Server prior to Dynamic Server 2000 (version 9.2), stored procedure syntax required a semicolon at the end of the returning clause, or the header ended with the close parenthesis following the parameter list.
In Dynamic Server 2000, the semicolon at the end of the header is optional. Without the semicolon, or without a begin label, the Replication Agent cannot distinguish the routine header from the routine body.
If the routine has any header syntax elements following the parameter list, such as the specific name, the semicolon must be used at the end of all the header options, or a begin label must be used to designate the beginning of the statement block. Otherwise, Replication Agent cannot mark the UDR for replication.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
