Skip to Content
avatar image
Former Member

excluding

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 18, 2006 at 07:31 AM

    hi Alfonso,

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

    you can try skip_record, check threads

    how-to-skip-a-record-in-transfer-rule

    writing-a-routine

    hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 17, 2006 at 11:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Apr 18, 2006 at 01:09 AM

    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

    append-datapak-transfer-start-routine

    excluding-blank-field-in-infopackage-filter

    Restriction of data selection in update rule start routine.

    hope this helps.

    Add comment
    10|10000 characters needed characters exceeded