sourcedataparameter

This defines the various parameter values for each Source Data provided on the input.

Syntax:

[ DynamicComponentDependency ] sourcedataparameter SourceDataParameterName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name	Data Type	Description	Default Value
parameter_name	String(100)	Provides the name of the parameter.
source_data_type_id	String(32)	Specifies the source data type identifier.

Optional columns

Column Name	Data Type	Description	Default Value
sequence	Number	A uniquifier to allow multiple source datas of the same type to be specified.	1
parameter_value	String(1000)	Specifies the actual value of the parameter.



            sourcedataparameter SourceDataParameter {{SelectName}} {
               SELECT
                     ..                  parameter_name,
                     ..                  source_data_type_id,
                  -- optional columns
                     ..                  sequence,
                     ..                  parameter_value
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

SourceDataParameterName

Syntax:

<Identifier>

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