Hi all,
I am trying to migrate a job from OpenHub to Data Services.
The downstream application makes use of the Recordmode from Openhub as it treats new records ‘N’ differently from updated records.
I followed the logic in this link:
http://wiki.scn.sap.com/wiki/display/EIM/Extractor+RecordMode
And wrote a function to add RECORDMODe to my extractor:
Return decode(
($ODQ_CHANGEMODE = 'C' and $ODQ_ENTITYCNTR = '1') , 'N',
($ODQ_CHANGEMODE = 'U' and $ODQ_ENTITYCNTR = '-1'), 'X',
($ODQ_CHANGEMODE = 'U' and $ODQ_ENTITYCNTR = '1') , ' ',
($ODQ_CHANGEMODE = 'D' and $ODQ_ENTITYCNTR = '-1'), 'R',
($ODQ_CHANGEMODE = 'D' and $ODQ_ENTITYCNTR = '0') , 'D',
($ODQ_CHANGEMODE = 'U' and $ODQ_ENTITYCNTR = '0') , 'A', 'N' );
This has now been running for a week, however nothing has come through the extractor marked as ‘N’.
Openhub however does have records marked as ‘N’. Any idea why this might be ? either the logic above is wrong, or something is being does differently in OpenHub.
Help is appreciated !
Thanks.
Leigh Kennedy (BOB member since 2012-01-17)