Understanding criteria for history inquiry transactions
The retrieval of audit data from the history tables brings back records according to the criteria described in this topic.
The returned audit records:
- Have a last update date in the past that is earlier than and closest to the date entered by the client.
- Have an end date, if relevant, that is NULL. Only one copy of the record can be active at any point in time.
The format for the DWLControl <inquireAsOf> element must:
- Have at least a date portion that complies with the date format specified in the /IBM/CoreUtilities/DateValidation/dateFormat configuration. See Elements in the Configuration and Management component for more information.
- Use a space to separate the date and time portion if a time portion is entered; a time portion is optional; if a time portion is not entered the default time is set to 23:59:59.0, for Oracle, or 23:59:59.000, for DB2®
- Specify time (24hr) in hours and minutes separated by a colon, for example 11:14; seconds are not considered
The following <inquireAsOfDate> element is valid assuming the
value of /IBM/CoreUitlities/DateValidation/dateFormat resolves to
the following format:
YYYY_MM_DD
where _
represents
the configured separator, -
, in the /IBM/CoreUtilities/DateValidation/dateSeparator
configuration:: <inquireAsOfDate>2002-06-13 11:14</inquireAsOfDate>
Note that <inquireAsOfDate>2002-06-13</inquireAsOfDate> would also be valid, with the time assumed to be the default.
The /IBM/DWLCommonServices/DateValidation/dateFormat record specifies the format for the year, month, and date portion of the date field.