objectdeletion

In order to delete an object from the DSE data set, an object deletion must be sent.Deletions should be done prior to new data stream being loaded. If referentialconstraints are broken then object exceptions will be created. When deletingobjects consider the impacts in terms of cascade deletes. Object deletions canhave a negative impact on the performance of the system and should be avoidedif possible. Note that to update an object you do not need to delete it first just send in the amended object using the same primary key.

Syntax:

[ DynamicComponentDependency ] objectdeletion ObjectDeletionName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Optional columns

            objectdeletion ObjectDeletion {{SelectName}} {
               SELECT
                     ..                  object_pk_name1,
                     ..                  object_pk1,
                     ..                  object_type_id,
                  -- optional columns
                     ..                  object_pk_name2,
                     ..                  object_pk_name3,
                     ..                  object_pk_name4,
                     ..                  object_pk2,
                     ..                  object_pk3,
                     ..                  object_pk4
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling ObjectDeletion.

ObjectDeletionName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:48.