In common with most other databases, a Structured Query Language (SQL) interface is available for DP4. There are three main ways of using the DP4 SQL interface:
You can run the DP4 SQL Interpreter to interrogate your DP4 database interactively. This method is useful for trying out SQL that you will use one of the other ways
You can also run the DP4 SQL Interpreter using with statements supplied from a file of input statements with the results also written to a file.
You can use the Microsoft ODBC interface to develop an application. This is a standard interface for developing applications that can be run against any database management system that supports ODBC, including DP4. The ODBC interface can also be used to access DP4 databases running on the Linux operating system.
More information on SQL is contained in the following topics: