excluding

[Former Member]

Hi,

Is it possible to exclude loading by not deleting the data package?

When a data_package is deleted (routine), does it mean a particular record within it or all the records of a data package?

Thanks,

Alfonso

[edwin_harpino · Accepted solution]

hi Alfonso,

i just realized '.. loading by <b>not</b> deleting ...'

you can try skip_record, check threads

hope this helps.

[edwin_harpino]

hi Alfonso,

yes, it's possible to exclude loading by deleting the data package, we can do this in start routine of transfer rules or update rules.

in transfer rules routine we use code like

delete datapak where <condition>.

e.g we don't want other language than English, then we can put

delete datapak where langu <> 'E'.

• langu is the field name in transfer structure.

in update rules

delete data_package where langu <> 'E'.

->datapak in transfer rules, data_package in routine.

when data_packag is deleted, it means only records that meet the condition are deleted.

take a look threads

hope this helps.

[Former Member]

Hello Alfonso,

It depends on where you have placed the delete commnand. If it is inside the loop, then record corresponding to that particular iteration is deleted. If the delete command is not within a loop, all the records ( satisfying the condtion, if mentioned) will be deleted. If a delete command without a condition is mentioed, all records of data package are deleted.

Hope it helps.

Regards,

Praveen

[Former Member]

Dear expert,

Could you provide the syntax structure for non-deletion filtering?

Regards,

Alfonso

[Former Member]

Use syntax..

DELETE DATA_PACKAGE WHERE <condition>.

DATA_PACKAGE is internal table which contains the incoming records in transfer structure format(transfer rules) or communication structure format(update rules).

Use DATAPAK in transfer rules(as suggested by AHP).

I think by non-deletion u mean that u do not want to delete some records that satisfy some particular condition.

Specify that condition in the where clause.

cheers,

Vishvesh