List of ODBC key fields
Some ODBC key fields are common to all records, and some are specific a record. This section presents the ODBC key fields common to all records. You need the ODBC key fields to use record data stored in the Store database with PFM - Manager.
The table below lists the ODBC key fields common to all records. For details about the ODBC key fields specific to each record, see the details of each record.
|
ODBC key field |
ODBC format |
Delta |
Description |
|---|---|---|---|
|
record-ID_DATE |
SQL_INTEGER |
Internal |
Key in the record that indicates the record creation date |
|
record-ID_DATETIME |
SQL_INTEGER |
Internal |
Combination of the record-ID_DATE and record-ID_TIME fields |
|
record-ID_DEVICEID |
SQL_VARCHAR |
Internal |
instance-name[host-name] |
|
record-ID_DRAWER_TYPE |
SQL_VARCHAR |
Internal |
Type. Valid values are as follows: m: Minute H: Hour D: Day W: Week M: Month Y: Year |
|
record-ID_PROD_INST |
SQL_VARCHAR |
Internal |
Instance name of PFM - Agent |
|
record-ID_PRODID |
SQL_VARCHAR |
Internal |
Product ID of PFM - Agent |
|
record-ID_RECORD_TYPE |
SQL_VARCHAR |
Internal |
Identifier indicating the record type (4 bytes) |
|
record-ID_TIME |
SQL_INTEGER |
Internal |
Record creation time (Greenwich mean time (GMT)) |