Archive File Collection Subsets

You can specify a subset of files in an Archive File Collection using a data source definition, connection string, or SQL WHERE clause.

See Define the Data Source on the ODM Optim Connect Server and Runtime Connection Information.

The PST_AF_SUBSET pseudocolumn is logically added to each archived table during ODM processing and allows you to create a subset using an SQL WHERE clause. Use the following syntax:

PST_AF_SUBSET=AF_IN(n,n...)' | ‘AF_ID_RANGE(x,y)' |  ‘AF_DATE_RANGE(yyyy-mm-dd-hh:mm:ss,yyyy-mm-dd-hh:mm:ss)'
‘AF_IN(n,n,...)'
Archive Files to include, where n is an Archive File name, GUID, or Archive File ID.
‘AF_ID_RANGE(x,y)'
A range of Archive File IDs, where x is the start and y is the end.
‘AF_DATE_RANGE (yyyy-mm-dd-hh:mm:ss, yyyy-mm-dd-hh:mm:ss)'
A range of Archive File creation dates. You must include the time of day (hh:mm:ss). You can use zeros to specify the time (e.g., 00:00:00).

The subset criteria can only be specified once in an SQL statement. If subset criteria is specified in the data source or connection string, the WHERE clause subset must be a subset of that criteria.



Feedback