List of ODBC key fields
Some ODBC key fields are common to all records, while others are specific to individual records. The ODBC key fields are necessary to use the data retrieved from records stored in the Store database on PFM - Manager.
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) |