Sybase DC38133-01-0902-01 manual Here is a sample insert into the table from the above error, 248

Column	Description
pub	Current publisher of the database (lets you know at what
	database it was inserted)
remoteuser	Remote user applying the message (lets you know what
	database it came from)
errormsg	Error message passed to the Replication_error procedure

Here is a sample insert into the table from the above error:

INSERT INTO cons.replication_audit ( id,

pub,

remoteuser,

errormsg,

"timestamp")

VALUES

( 1, ’cons’, ’sales’,

’primary key for table ’’reptable’’ is not unique (-193)’, ’1997/apr/21 16:03:13.836’)

COMMIT WORK

Since Adaptive Server Anywhere supports calling external DLLs from stored procedures you can also design a paging system, instead of using Email.

An example of an error For example, if a row is inserted at the consolidated using the same primary key as one inserted at the remote, the Message Agent displays the following errors:

Received message from "cons" (0-0000000000-0)

SQL statement failed: (-193) primary key for table ’reptable’ is not unique

INSERT INTO cons.reptable( id,text,last_contact )

VALUES (2,’dave’,’1997/apr/21 16:02:38.325’)

COMMIT WORK

The messages that arrived in Doe, John and Elton, John’s email each had a subject of SQL Remote Error:

primary key for table ’reptable’ is not unique (-193)

INSERT INTO cons.reptable( id,text,last_contact ) VALUES (2,’dave’,’1997/apr/21 16:02:52.605’)

248