List of ODBC key fields
Some ODBC key fields are common to all records, while others are specific to individual records. This section presents the ODBC key fields common to all records. With PFM - Manager, ODBC key fields are required in order for you to use SQL statements to access record data stored in the Store database.
The table below lists the ODBC key fields that are common to all records. For details about the ODBC key fields that are specific to each record, see the individual record descriptions.
ODBC key field |
ODBC format |
Data |
Explanation |
---|---|---|---|
record-ID_DATE |
SQL_INTEGER |
Internal |
Record key indicating the date when the record was generated |
record-ID_DATETIME |
SQL_INTEGER |
Internal |
Combination of record ID_DATE field and record ID_TIME field |
record-ID_DEVICEID |
SQL_VARCHAR |
Internal |
Instance name [host name] |
record-ID_DRAWER_TYPE |
SQL_VARCHAR |
Internal |
|
record-ID_PROD_INST |
SQL_VARCHAR |
Internal |
PFM - RM for Virtual Machine instance name |
record-ID_PRODID |
SQL_VARCHAR |
Internal |
PFM - RM for Virtual Machine product ID |
record-ID_RECORD_TYPE |
SQL_VARCHAR |
Internal |
ID indicating a record type (4 bytes) |
record-ID_TIME |
SQL_INTEGER |
Internal |
Time at which the record was generated (Greenwich Mean Time) |