Skip to Content
author's profile photo Former Member
Former Member

delta update for deleted records

Hi,

I use delta update for my data. As destination I use ODS object and this ODS contains two keys: key1 and key2. On step of preparing data for extraction, key2 is lost(we can't determine it) - key1 is known only.

I'm finding a way how to update ODS by deleted records('D' update mode) if this records contain only key1 value(key2 is empty). I need to delete all records with key1 only, key2 is not important for this update.

Is it possible to set key2 some BW specific value, which will be accepted as equal for old key2 values ?

Or some other standart ways are known for this situation ?

Thanks in advance,

Fiodar.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Feb 09, 2005 at 03:22 PM

    I would use the update rules to read the active data table of the ODS. There you can read all the key2 values for a given key1.

    If you get one row with key1 filled and key2 = '*' (for example you could split it into multiple records, one per key2. A sample coding might look like:

    LOOP AT DATA_PACKAGE into l_d_data_package.
      IF key2 = '*'.
        DELETE DATA_PACKAGE.
        SELECT * FROM /BIC/AMY_ODS00 INTO l_d_my_ods
          WHERE key1 = l_d_data_package-key1.    
          l_d_data_package-key2 = l_d_my_ods-key2.
          append l_d_data_package to DATA_PACKAGE.  
        ENDSELECT.
      ENDIF.  
    ENDLOOP.
    

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.