Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

column based Publication / subscription

2 posts in Replication Last posting was on 2006-03-22 08:14:33.0Z
Paul Man Posted on 2006-03-21 18:10:23.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
Subject: column based Publication / subscription
Date: Tue, 21 Mar 2006 18:10:23 -0000
Lines: 13
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 82.141.233.142
Message-ID: <442040cc@solutions.advantagedatabase.com>
X-Trace: 21 Mar 2006 11:07:08 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:103
Article PK: 1133961

Hi

I've been trying to find out about the following with the new V8
replication.

I want to publish a table but when subscribing I only want to update certain
fields in the table plus based on the data coming in I want to update some
totals in another table (while a trigger is possible - it must only apply to
replicated data). Is this possible? With another well known database, this
is possible by defining the SQL.


Joachim Duerr (ADS Support) Posted on 2006-03-22 08:14:33.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: column based Publication / subscription
Newsgroups: Advantage.Replication
References: <442040cc@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.17.6.5
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 84.158.157.230
Message-ID: <44210769@solutions.advantagedatabase.com>
Date: 22 Mar 2006 01:14:33 -0700
X-Trace: 22 Mar 2006 01:14:33 -0700, 84.158.157.230
Lines: 33
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!84.158.157.230
Xref: solutions.advantagedatabase.com Advantage.Replication:104
Article PK: 1133962


Paul Man wrote in <442040cc@solutions.advantagedatabase.com>:

> I've been trying to find out about the following with the new V8
> replication.
>
> I want to publish a table but when subscribing I only want to update
> certain fields in the table plus based on the data coming in I want
> to update some totals in another table (while a trigger is possible -
> it must only apply to replicated data). Is this possible? With
> another well known database, this is possible by defining the SQL.

You will be able to do it with the upcoming 8.1 release. Currently it's
only possible to set a horizontal filter. Another approach: Create a
table which contains only the needed data, fill it through a trigger on
the main table and also set a trigger on that table to move the data
back to the main table.

--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de
*********** European Advantage Conference (EAC) 2006 ****************
Do you want to develop faster, deliver better solutions and drive your
business forward?
Plan to attend now THE Advantage event of the Year!
+++ UK - London, 8.-9. May
+++ GERMANY - Frankfurt, 11.-12. May
+++ ITALY - Milano, 15. May
EARLY BIRD RATES open until 31. March: 199 ?/? instead of 299 ?/?
(Milano 149/199 ?)
Click for Details: http://www.AdvantageDatabase.com/EAC2006
*********** European Advantage Conference (EAC) 2006 ****************