List of ODBC key fields
Some ODBC key fields are common to all records, and some are specific to particular records. This section explains the ODBC key fields that are common to all 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 common to all records. For details about the ODBC key fields specific to particular records, see the descriptions of the records.
ODBC key field |
ODBC format |
Data |
Description |
---|---|---|---|
record-ID_DATE |
SQL_INTEGER |
Internal |
Record key field that indicates the record's creation date |
record-ID_DATETIME |
SQL_INTEGER |
Internal |
Combination of the two fields record-ID_DATE and record-ID_TIME |
record-ID_DEVICEID |
SQL_VARCHAR |
Internal |
Name of the host where PFM - Agent is running |
record-ID_DRAWER_TYPE |
SQL_VARCHAR |
Internal |
|
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)) |