Skip to Content
0
Dec 13, 2011 at 10:00 PM

Script logic: clear data in a target application

400 Views

Hi all,

I need to copy data from an application (BILLING) to another one (BUDGET). I use *DESTINATION_APP to execute the copy and it works fine.

Before copying data, I need to clear existing data in target application BUDGET even if no data exists in the source application BILLING. For example, I can have data on entity E1 in BUDGET application and no data on entity E1 in BILLING application.

If I use the following command data on E1 are not cleared:

XDIM_MEMBERSET ENTITY=<ALL>

*DESTINATION_APP = BUDGET

*WHEN CATEGORY

*IS ACTUAL

*REC(EXPRESSION=0)

*ENDWHEN

So I tried to add the command *WHEN_REF_DATA=MASTER_DATA before the *WHEN command in order to ensure that all entities are cleared but it doesn't work.

Any idea to help me?

regards,

Romuald