systemdataupdate

This is used to update/delete data in the system database. Works by defining the primary key and either the value to be amended or the whole row to be deleted.

Syntax:

[ DynamicComponentDependency ] systemdataupdate SystemDataUpdateName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
object_pk_name1 String(40) Primary Key name 1.
object_pk1 String(32) Primary Key value 1.
object_type_id String(40) Name of the table to update.

Optional columns

Column Name Data Type Description Default Value
delete_row Number (0 = False, 1 = True) Specify the row should be deleted. False
column_name String(32) Column to update.
column_value String(100) Value to update the column to.
object_pk_name2 String(40) Primary Key name 2.
object_pk_name3 String(40) Primary Key name 3.
object_pk_name4 String(40) Primary Key name 4.
object_pk_name5 String(40) Primary Key name 5.
object_pk2 String(32) Primary Key value 2.
object_pk3 String(32) Primary Key value 3.
object_pk4 String(32) Primary Key value 4.
object_pk5 String(32) Primary Key value 5. 


            systemdataupdate SystemDataUpdate {{SelectName}} {
               SELECT
                     ..                  object_pk_name1,
                     ..                  object_pk1,
                     ..                  object_type_id,
                  -- optional columns
                     ..                  delete_row,
                     ..                  column_name,
                     ..                  column_value_,
                     ..                  object_pk_name2,
                     ..                  object_pk_name3,
                     ..                  object_pk_name4,
                     ..                  object_pk_name5,
                     ..                  object_pk2,
                     ..                  object_pk3,
                     ..                  object_pk4,
                     ..                  object_pk5
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

SystemDataUpdateName

Syntax:

<Identifier>

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