DATE and VERSION: Specifying the date or version of the aggregate group

Explanation: DATE and VERSION are optional parameters of AGGREGATE.

DATE(yyyy/mm/dd)
specifies that all versions of the aggregate group created on that date are listed:
  • yyyy is the 4-digit year (1992)
  • mm is the month (01-12)
  • dd is the day of the month (01-31)
VERSION(nnnn)
specifies the version number of a specific aggregate group version to be listed. VERSION is not valid when AGGREGATE(*) is specified.

Defaults: If you do not specify either DATE or VERSION with the LIST AGGREGATE command, you receive a listing of all active versions of an aggregate.