Thanks Tim
Kish
>From: "Ohling, Tim R - CNF" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: [EMAIL PROTECTED]
>Subject: RE: DB2EUG: Replication -- Source delete still need to Insert int
>o target table
>Date: Wed, 31 Oct 2001 10:50:19 -0800
>
>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
>
_________________________________________________________________
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
