15.4.4 Specifying common key fields
The PFM - Agent or PFM - RM store database contains records with keys. You must specify at least one ODBC key field for a query.
The following table lists and describes the ODBC key fields that are common among PFM - Agents or PFM - RM.
Common ODBC key field |
Description |
---|---|
record-id_DATE |
The record key that indicates the record creation date |
record-id_DATETIME |
Combination of record-id_DATE and record-id_TIME fields |
record-id_DEVICEID |
|
record-id_DRAWER_TYPE |
Classification. Valid values are as follows: m: minute H: hour D: date W: week M: month Y: year |
record-id_PROD_INST |
Name of monitored system |
record-id_PRODID |
Product identifier |
record-id_RECORD_TYPE |
The 4-byte identifier that indicates the record type |
record-id_TIME |
Record creation time (GMT) |
- Note:
-
For record-id, enter the record ID of each PFM - Agent or PFM - RM. For details on record IDs of each PFM - Agent or PFM - RM, see the chapters that describe records (record list) in the PFM - Agent or PFM - RM manuals.
Depending on the PFM - Agent or PFM - RM records, you may also be able to specify key fields other than common ODBC key fields. For details on available ODBC key fields, see the chapters that describe records (ODBC key field list) in the PFM - Agent or PFM - RM manuals.