ramdataupdate

Used to update a particular value of the database, or delete rows.

Syntax:

[ DynamicComponentDependency ] ramdataupdate RAMDataUpdateName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
object_pk_name1 String(32) The column name of one of the primary key columns in this table.
object_pk1 String(32) The value of the column named above for this row.
object_type_id String(40) The name of the table that the row the update applies to is in.

Optional columns

Column Name Data Type Description Default Value
delete_row Number (0 = False, 1 = True) True is the entire row defined is to be deleted. False
column_name String(32) The column name of the column for which the new value applies.
column_value String(100) The updated value for this column.
object_pk_name2 String(32) The column name of one of the primary key columns in this table.
object_pk_name3 String(32) The column name of one of the primary key columns in this table.
object_pk_name4 String(32) The column name of one of the primary key columns in this table.
object_pk2 String(32) The value of the column named above for this row.
object_pk3 String(32) The value of the column named above for this row.
object_pk4 String(32) The value of the column named above for this row. 


            ramdataupdate RAMDataUpdate {{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_pk2,
                     ..                  object_pk3,
                     ..                  object_pk4
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMDataUpdateName

Syntax:

<Identifier>

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