sourcedata

Defines the source of additional data to be added to input. By including a Source Dataentity in the input, additional data from the source is automatically extractedand included in the input. This extraction and insertion of data occurs automatically during an initial load of scheduling data. This process is used to load data held inother systems or from an external database by calling a database procedure.The Schedule Input Manager writes the merged input to Input History and the Scheduling Database asnormal.

Syntax:

[ DynamicComponentDependency ] sourcedata SourceDataName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Optional columns

            sourcedata SourceData {{SelectName}} {
               SELECT
                     ..                  source_data_type_id,
                  -- optional columns
                     ..                  sequence,
                     ..                  source_dataset_id,
                     ..                  source_db
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

SourceDataName

Syntax:

<Identifier>

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