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
