To be able 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 semi-colon at the end of the returning clause, or the header ended with the close parenthesis following the parameter list.
In Dynamic Server 2000, the semi-colon at the end of the header is optional. Without the semi-colon, 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 semi-colon 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.
