Contents Index REPLICATION_ERROR option [replication] RETURN_DATE_TIME_AS_STRING option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

REPLICATION_ERROR_PIECE option [replication]


Function 

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.

Allowed values 

Stored procedure name

Default 

No procedure

Description 

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.


Contents Index REPLICATION_ERROR option [replication] RETURN_DATE_TIME_AS_STRING option [database]