No update in update rule by routine

[Former Member]

Hi,

Is it possible to set to no update in update rules using a routine?

I am updating to ODS in the update rules if value is 'X' for an char want no update - so that it will retain the value in the target ODS for that char for the key combination. The value 'X' is being derived in the start routine.

Thanks

Unni

[Former Member]

Hi Unni,

In the start routine in the Update Rules tab put in a statement

DELETE DATA_PACKAGE WHERE INFOOBJECT EQ 'X'.

This will delete all the records where the InfoObject in Consideration contains 'X'.

Hope this Helps.

Ashish.

[Former Member]

If I understand your question correctly, I believe you can do this with the return codes.

E.g.

• if the returncode is not equal zero, the result will not be updated

RETURNCODE = 0.

• if abort is not equal zero, the update process will be canceled

ABORT = 0.

[GFV]

Hi Unni,

I've tried in the past to, but it didn't work ... since you are updating an ODS a workaround (not so good I know) is to replace the value of the field sent by the Comm Structure with the result of a SELECT SINGLE pointed on the active table of the ODS.

I mean

IF FLAG = 'X'

SELECT SINGLE FIELD_XXX INTO RESULT

FROM /BIC/A<YOUR_ODS>00

WHERE KEY1 = COMM_STRUCTURE-KEY1

AND KEY2 = COMM_STRUCTURE-KEY2

...

ENDIF.

I know it's not a pretty solution from a performance point of view ...

Let me know if you find a better solution

Hope it helps

GFV