Hi Ohling Can you please give me some more details how you have implemented the scenario.
Where should be the CASE statement kept in the subscription? Is CASE is written in ASN.IBMSNAP_SUBS_SOLS table EXPRESSION column? If not is it written in any other ASN tables, if so which table, which column and can you give me the exact syntax of CASE. how it is the Data Propagator expecting, I am asking this question as I have seen DP is very sensitive event with spaces in the expression. If you can give me the step by step implementation that will be a great help. Thanks for your help. Kish >From: "Ohling, Tim R - CNF" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: [EMAIL PROTECTED] >Subject: RE: DB2EUG: Replications question -- Datapropagator >Date: Thu, 25 Oct 2001 15:39:08 -0700 > >Yes. We've done similar things with CASE expressions as well as coding >triggers to do added work with transaction types (such as deletes) that >needed extra work at propagation time. > >HTH, >Tim > > > -----Original Message----- > > From: kishore lingamallu [SMTP:[EMAIL PROTECTED]] > > Sent: Thursday, October 25, 2001 12:59 PM > > To: [EMAIL PROTECTED] > > Subject: RE: DB2EUG: Replications question -- Datapropagator > > > > Hi > > > > I want to set up the propagator on a table and here is the information >the > > > > tables are in SOURCE and TARGET databases respectively. > > > > Source Table: SOURCE_TAB > > ------------------- > > SOU_COL1 > > SOU_COL2 > > SOU_COL3 > > > > CD Table: SPURCECD TAB > > ---------------------- > > IBMSNAP_UOWID > > IBMSNAP_INTENTSQ > > IBMSNAP_OPERATION > > XSOU_COL1 > > SOU_COL1 > > XSOU_COL2 > > SOU_COL2 > > XSOU_COL3 > > SOU_COL3 > > > > Target Table: TARGET_TAB > > ------------------- > > TAR_COL1 > > TAR_COL2 > > TAR_COL3 > > TAR_COL4 > > > > I want to populate the data in the target table and the value of >TAR_COL4 > > > > should be basing on the IBMSNAP_OPERATION column value. > > > > Example: > > IF IBMSNAP_OPARTION is 'D' then TAR_COL4 should be 9999 > > > > How can I implement this. > > > > Is CASE (SQL operation) is allowed in the SQL Expression tab? > > > > Thanks > > > > Kish > > > > > > > > _________________________________________________________________ > > Get your FREE download of MSN Explorer at >http://explorer.msn.com/intl.asp > > > > > > ===== > > To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > > For other info (and scripts), see > > http://people.mn.mediaone.net/scottrmcleod > >===== >To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] >For other info (and scripts), see >http://people.mn.mediaone.net/scottrmcleod > _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
