Is it safe to use @@identity with replication enabled on Sybase ASE 15.

Question

I am using @@identity to fetch recently updated identity column. Am not sure if this presents any problem when used on a SERVER with replication enabled. Tried googling but no luck. Can someone explain me how this works?

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.pb_10.5.connpb/html/connpb/connpb65.htm

Answer 1

According to this reference, Sybase supports the Scope_Identity function which should return the last identity value created by your procedure. I think using that is safer than @@identity in most situations but I am not sure how it works with replication.