Apollo SQL Overview

Apollo SQL

Free SQL-92 Query Processor

Apollo SQL 6.1 Benchmarks
Apollo SQL 6.1 Explained

Apollo SQL™ is a high-speed local SQL engine add-on that provides database management for CA-Clipper (.DBF/.DBT/.NTX/.NSX), FoxPro (.DBF/.FPT/.IDX/.CDX), as well as HiPer-SIx (.DBF/.SMT/.NSX) index and memo data files. The following are some sample supported Apollo SQL statements:

SELECT * FROM mydata WHERE (state = "CA")

SELECT (fname, lname, age) FROM cust WHERE (age > 21)
   GROUP BY lname ORDER BY fname

INSERT INTO CUST (fname, lname, email)
   VALUES ( "John", "Smith", "js@abc.com")

INSERT INTO CUST (fname, lname, email)
   VALUES ( "John", "Smith", "js@abc.com")

UPDATE cust SET fname = "Joseph" WHERE (ssn = "123-12-1234")

Apollo SQL works as an add-on engine for Apollo .NET™, Apollo ASP™, Apollo VCL™, Apollo OLE DB™, Apollo COM™ and Apollo Data Control™ that allows developers to use SQL-92 with these engines. The Apollo SQL add-on allows Apollo engines to use SQL in local or on a shared network, without having to connect to the Apollo Server.

Apollo SQL is an ideal solution for developers that want to use SQL in their stand-alone database applications. Developers with applications deployed in a peer-to-peer environment should consider moving to Apollo Database Server™. Apollo SQL makes migration to client/server computing seamless since the Apollo Server has Apollo SQL built-in.

Features

Apollo SQL sports many powerful features such as aggregate functions, nested SELECTs, JOINs, DISTINCT clause and even cross-tab queries (columns defined by table data). Apollo SQL is very fast and it very easy to use for developers with a basic understanding of SQL.

DML/DDL Statements

Apollo SQL supports the following data definition language (DDL) and manipulation language (DML) statements:

DML/DDL Statements	Description
ALTER TABLE	Alter a table structure.
CREATE INDEX	Creates a new index.
CREATE TABLE	Creates a new table.
DELETE	Deletes existing data from a table.
DROP INDEX	Deletes an index.
DROP TABLE	Deletes a table.
MERGE	Appends one result set to another result set.
INSERT	Adds new data to a table.
SELECT	Retrieves existing data from a table.
TRANSFORM…PIVOT	Creates a cross-tab (spreadsheet-style) query UPDATE Modifies existing data in a table.

Clause Statements

Apollo SQL supports the following clauses:

Clause	Description
FROM	Specifies the tables used for the statement.
GROUP BY	Specifies the columns used to group rows.
HAVING	Specifies filter criteria using aggregated data.
ORDER BY	Specifies the columns on which to sort the result set.
WHERE	Specifies filter criteria to limit rows retrieved.

Documentation

Apollo SQL includes a comprehensive Windows help (.CHM).

System Requirements

Apollo .NET, Apollo ASP, Apollo VCL, Apollo OLE DB Provider or Apollo COM is required and the versions must be synchronized (e.g. Apollo SQL 6.1 requires Apollo VCL 6.1 to work)

Runtime License/Royalty Requirements

Apollo SQL has no runtime license or royalty requirements.

Apollo Database Engines



	©1999-2008 Vista Software. All rights reserved. http://www.vistasoftware.com Terms of use.