Caché SQL Basics describes the fundamental features of Caché SQL (such as tables and queries), especially those that are not covered by the SQL standard or are related to the Caché unified data architecture.
Language Elements describes how Caché SQL handles the basic elements common to any programming language: numbers, strings, operators, NULL, and comments.
Identifiers describes the conventions used for naming entities within Caché SQL.
Data Definition: creating tables and views:
Defining Tables describes how to define tables in Caché SQL, by defining persistent classes or by using an SQL DDL statement.
Defining Views describes how to define views in Caché SQL by using the Management Portal or by using a DDL statement.
Importing SQL Code describes how to execute SQL statements by importing them from a text file. This interface can be used for Caché SQL code or SQL code in other vendor formats. Import SQL code can be used to define tables and to populate tables with data; it cannot be used to query data.
Using the Caché SQL Gateway describes how to obtain access to external databases via JDBC and ODBC, enabling you to treat external tables as if they were native Caché tables.