List of ODBC key fields
Some ODBC key fields are common to all records while others are unique to some records. This section shows the ODBC key fields that are common to all records. ODBC key fields are required if you use an SQL statement in PFM - Manager to utilize the record data stored in the Store database.
The table below shows a list of ODBC key fields common to all records. For details about the ODBC key fields unique to each record, see the explanation of each record.
Table 7-2 List of ODBC key fields common to all records
ODBC key fields | ODBC format | Data | Explanation |
---|---|---|---|
record-id_DATE | SQL_INTEGER | Internal | Record key indicating the date on which the record was created |
record-id_DATETIME | SQL_INTEGER | Internal | Combination of the record-id_DATE field and the record-id_TIME field |
record-id_DEVICEID | SQL_VARCHAR | Internal | Name of the host on which PFM - Agent is running |
record-id_DRAWER_TYPE | SQL_VARCHAR | Internal | Category. The following values are valid: m: Minute H: Hour D: Day W: Week M: Month Y: Year |
record-id_PROD_INST | SQL_VARCHAR | Internal | Name of the PFM - Agent instance |
record-id_PRODID | SQL_VARCHAR | Internal | PFM - Agent's product ID |
record-id_RECORD_TYPE | SQL_VARCHAR | Internal | Record type identifier (4 bytes) |
record-id_TIME | SQL_INTEGER | Internal | Time at which the record was created (Greenwich Mean Time) |