Previous Topic: Extracting Delta Rowsets into DSV Output DatasetsNext Topic: Parameter Specifications

AutoCollect - Creating User Defined DELTA Rowsets › Extracting Delta Rowsets into DSV Output Datasets › Selection Parameters

Selection Parameters

For the DSVOUT function, you can use the following parameters to select the Delta rowsets used for input to the creation of the sequential output file.

MUFNAME=mufname

Specifies to restrict processing to Delta rowsets from this selected MUF only. Therefore, to select rowsets for more than one MUF, execute this function once for each MUF you want to target.

TYPE=type

Specifies to restrict the Delta rowsets that you want selected as input as follows:

AVGPERF

Selects only Delta rowsets built by the AUTOCOLL OPTION=AVGPERF function

BASELINE

Selects only Delta rowsets built by the AUTOCOLL OPTION=BASELINE function

INTERVAL

Selects only Interval Delta rowsets built by the AUTOCOLL OPTION=DELTACRE function

LAST

Selects only Last Delta rowsets built by the AUTOCOLL OPTION=DELTACRE function

SUMMARY

Selects only Delta rowsets built by the AUTOCOLL OPTION=DELTACRE function

DATERG

Select only Delta rowsets that have their D_MUF_END_DATETIME date value within the range of dates specified in this parameter.

The format of the entry is ccyymmddccyymmdd where the first 8 bytes are the starting date and the last 8 bytes are the ending date. The starting and ending date can be in the range of 19000101 to 39991231. The ending date must be equal to or greater than the starting date. If you do not specify a date range, the date value is not used when selecting a rowset.

TIMERG

Select only Delta rowsets that have their D_MUF_END_DATETIME time value within the range of times specified in this parameter.

The format of the entry is hhmmsshhmmss where the first 6 bytes are the starting time and the last 6 bytes are the ending time. The starting and ending time can be in the range of 000000 to 240000. The ending time must be equal to or greater than the starting time. If you do not specify a time range, the time value is not used when selecting a rowset.

USERTAG

Select only Delta rowsets that have this value in their USERTAG column. If you do not specify a USERTAG, the USERTAG value is not used when selecting a rowset.