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
