Command Reference¶

SQL databases offer a quicker, more robust database manager than the DataFlex data manager. Mertech drivers handle most of the intricacies of using DataFlex, a record-oriented programming environment, with Oracle, MS SQL Server (a set oriented database engine), DB2, MySQL or PostgreSQL. However, there are some areas where, with a little tuning of the code, a DataFlex program can offer significant advantages over the SQL engines.

Embedded SQL statements or stored procedure calls can be used for procedures that manipulate a large number of tables and data. By using stored procedures, most of the processing is completed on fast servers and very little data transfer takes place between the server and the client. To achieve these performance objectives, Mertech has developed commands that allow you to optimize your programs for faster data access. These commands and processes are discussed in detail in the following sections.

List of commands: