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 fieldsODBC formatDataExplanation
record-id_DATESQL_INTEGERInternalRecord key indicating the date on which the record was created
record-id_DATETIMESQL_INTEGERInternalCombination of the record-id_DATE field and the record-id_TIME field
record-id_DEVICEIDSQL_VARCHARInternalName of the host on which PFM - Agent is running
record-id_DRAWER_TYPESQL_VARCHARInternalCategory. The following values are valid:
m: Minute
H: Hour
D: Day
W: Week
M: Month
Y: Year
record-id_PROD_INSTSQL_VARCHARInternalName of the PFM - Agent instance
record-id_PRODIDSQL_VARCHARInternalPFM - Agent's product ID
record-id_RECORD_TYPESQL_VARCHARInternalRecord type identifier (4 bytes)
record-id_TIMESQL_INTEGERInternalTime at which the record was created (Greenwich Mean Time)