This guide describes how to install, configure and use four SQL-related products:
The DP4 Gateway ADCs (Auxiliary Database Controllers)
On Microsoft Windows platforms the ODBC Gateway ADC product offers DP4 applications seamless access to foreign (non-DP4) databases that are compliant with the ODBC interface. The Oracle OCI Gateway ADC perfroms the same function for Oracle databases using the native Oracle interface, and is available on both Windows and Unix platforms.
Under Windows and Windows NT this product allows third-party applications that support the ODBC standard to access DP4 databases.
This product, available on many platforms, allows you to submit SQL statements to the DP4 SQL Engine to query and update data on DP4 databases, either interactively or from a batch mode program that can be called from other programs.
Under Windows 3.1 this product (now just part of the SQL interface supplied for Windows 3.1) allows third-party applications that support the DDE standard to access DP4 databases.
The DP4 ODBC drivers and the SQL and DDE interface all ultimately depend on the DP4 SQL Engine. The SQL language understood by this component, and details of how SQL statements are translated into calls to the DP4 database manager are documented in the DP4 SQL Engine Reference.
Most of the examples in this manual use the SALESORD Database.
Suggestions for improvements or corrections to this manual are welcome. Find out how to comment here.