ASA Database Administration Guide
Database Options
Alphabetical list of options
For SQL Remote, the REPLICATION_ERROR_PIECE option works in conjunction with the REPLICATION_ERROR option to allow you to specify a long varchar stored procedure to be called by the Message Agent when a SQL error occurs.
This is a compatibility feature most useful for databases created with older versions of Adaptive Server Enterprise which do not support long varchar.
Stored procedure name
No procedure
If an error occurs and REPLICATION_ERROR is defined then the REPLICATION_ERROR procedure is called with the full error string.
If REPLICATION_ERROR and REPLICATION_ERROR _PIECE are both defined then the error is broken up into varchar pieces. REPLICATION_ERROR is called with the first piece and REPLICATION_ERROR_PIECE is called repeatedly with the remaining pieces.