Add the following bullet to the rs_subcmp procedure in the Replication Server Reference Manual:
Using the set textsize Adaptive Server command as part of the select statement can limit the amount of text compared. The following example shows the effect of setting the text size to 10. The first select statement returns 30 characters of text:
set textsize 30 select * from zetext a b c ---------- ----------------------- ------------- abba apples odd one here beta banana rotten caro celery not carrots
The next select statement sets the textsize to 10:
1> set textsize 10 select * from zetext 2> go a b c ---------- ----------------------- ------------- abba apples odd one beta banana rotten caro celery not carrots -------------------------------------------------------------------- (3 rows affected)