ramresourceretention

Defines periods of time where the resource is employed. If a resource has no retention they are considered as always available. Otherwise they are only available during the times specified.

Syntax:

[ DynamicComponentDependency ] ramresourceretention RAMResourceRetentionName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name	Data Type	Description	Default Value
id	String(32)	A unique id.
ram_resource_id	String(32)	The resource this applies to

Optional columns

Column Name	Data Type	Description	Default Value
is_dataset_transfer	Number (0 = False, 1 = True)	Internal use - this is set to true when transferring resources between datasets.	False
retention_end	Date	The end of the retention period
retention_start	Date	The start of the retention period



            ramresourceretention RAMResourceRetention {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  ram_resource_id,
                  -- optional columns
                     ..                  is_dataset_transfer,
                     ..                  retention_end,
                     ..                  retention_start
               FROM {{sourceTableName}}
               WHERE ...;
            }

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

RAMResourceRetentionName

Syntax:

<Identifier>

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