PxPlus SQL ODBC

Table Definitions

To access PxPlus data files in ODBC, the contents of the files (or tables) must be described for use with the PxPlus SQL ODBC Driver. Tables can be defined in two ways:

 

PxPlus Data Dictionary

This is the preferred method, as files are easily defined using NOMADS Data Dictionary Maintenance and are fully compatible with the PxPlus SQL ODBC Driver.

 

Formatted Text File (INI file)

Files are created manually. This method is required when files contains multiple record types.

Note:
Data Dictionary Maintenance allows the entry of multiple record definitions (as of PxPlus version 5). However, the PxPlus SQL ODBC Driver does not use this information. The PxPlus SQL ODBC Driver will read only the first record format.

Data Dictionary and INI file locations are defined for the PxPlus SQL ODBC Driver using the ODBC Data Sources application in Windows and the ODBC.ini file in UNIX/Linux. See Configuration Procedures.

This Help section describes both methods for defining data sources for use with the PxPlus SQL ODBC Driver: PxPlus Data Dictionary and INI Definition.

Terminology

When working with ODBC, the standard term for a set of data is a table. In PxPlus, a table is often a physical file. In this documentation, the terms table and file are both used. When the documentation refers to the data as stored on disk, the term physical file is used.

Note:
Due to the ability to store multiple record formats in a single physical file, there may be multiple logical tables for a single physical file.