Skip to Content

ODS to ODS recordmode missing

I have a ODS than is loaded from an R3 extractor and this ODS subsequently loads another ODS. The load from the first ODS to the second ODS there is no recordmode. All recordmodes are blank.

The problem is when a record in the first ODS is deleted because it receives a recordmode 'R' during an extraction from R3. Recordmode 'R' is not passed to the second ODS. The only record passed to the second ODS are negative qtys that in effect zero out the data in the second ODS. But the record is still in the second ODS.

Is there any way to get the first ODS to send recordmode 'R' to the second ODS so the record in the second is deleted?

Thanks,

Ron

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 09:31 PM

    Hi,

    hmmm, first thinking, it might b logic since your two ODS most probably have a different key, therefore passing the record mode from one ods to another one doesn't make sense.

    but some alternatives:

    - implement a ZRECORDMODE IObj in your first ODS with an overwrite update. Map this ZRECORDMODE to 0RECORDMODE of the second ODS. If your key is different in the second ODS it could be that several records get deleted or none; you'll have to test this!

    - in a start routine between both ODS loop at your package and check if the delta record exits in the first ODS (and/or in the second) and update the record mode according to your needs.

    hope this helps and am curious to follow this up...

    Olivier.

    Add comment
    10|10000 characters needed characters exceeded