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)'
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.