on 04-18-2006 12:21 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
94 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.