We did something like this in evaluation by creating a before insert trigger
on the CD table that intercepted every delete row and changing it to an
update with a delete status for the target table. I didn't do the trigger
and don't have the code handy, but it was pretty simple if I recall
correctly.
Tim
> -----Original Message-----
> From: kishore lingamallu [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, October 30, 2001 1:49 PM
> To: [EMAIL PROTECTED]
> Subject: RE: DB2EUG: Replication -- Source delete still need to
> Insert into target table
>
>
>
> Question : What need to be done if I want for the following scenario.
>
> Thanks Tim, for the previous help.
>
> Assume a row is deleted from the source table,
> Which puts a value for IBMSNAP_OPERATION = 'D' in the CD table.
> Still I want that row and want to insert into the target table.
>
> The source table and Target table has different primary keys so if this
> is
> possible then there should not be any rejection/errors.
>
> Kish
>
> >From: "Ohling, Tim R - CNF" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >Subject: RE: DB2EUG: Replications question -- Datapropagator
> >Date: Fri, 26 Oct 2001 13:23:31 -0700
> >
> >The CASE statements that we did were in the EXPRESSION of the
> >IBMSNAP_SUBS_COLS control table. The only things to watch out for are
> the
> >length of the string, the need to possibly wrap it across multiple lines
> of
> >the insert statement, and using double quote marks (") where SQL would
> >normally have single quote marks (').
> >
> >Example of the insert statement:
> >
> >INSERT INTO ASN.IBMSNAP_SUBS_COLS (
> >APPLY_QUAL,
> >SET_NAME,
> >WHOS_ON_FIRST,
> >TARGET_OWNER,
> >TARGET_TABLE,
> >COL_TYPE,
> >TARGET_NAME,
> >IS_KEY,
> >COLNO,
> >EXPRESSION
> >) VALUES (
> >'APPLYQUAL',
> >'SUBSSETNAME',
> >'S',
> >'TRGTOWN',
> >'TRGT_TABLE',
> >'C',
> >'COLUMN_NAME',
> >'Y',
> >0,
> >'CASE LEFT(SOURCE_COLUMN,1) WHEN "U" THEN "UUU" WHEN "X" THEN "XXX"
> >WHEN "N" THEN "NNN" WHEN "L" THEN "LLL" ELSE "AAA" END'
> >);
> >
> >
> >Tim
> >
> > > -----Original Message-----
> > > From: kishore lingamallu [SMTP:[EMAIL PROTECTED]]
> > > Sent: Friday, October 26, 2001 7:22 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: RE: DB2EUG: Replications question -- Datapropagator
> > >
> > > 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
> >
> >=====
> >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
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
