Ingres® 2006 - OpenSQL Reference Guide

Peter Kitson

ISBN : -

Order a printed copy of this book from Amazon --UNAVAILABLE--


Cover Design - Ingres® 2006 - OpenSQL Reference Guide
  

For your free electronic copy of this book please verify the numbers below. 

(We need to do this to make sure you're a person and not a malicious script)

Numbers

 



Sample Chapter From Ingres® 2006 - OpenSQL Reference Guide
     Copyright © Ingres Corporation



Chapter 1: Introduction


The OpenSQL Reference Guide describes OpenSQL usage and syntax. OpenSQL was specifically designed to be compatible across several SQL dialects. OpenSQL is functionally equivalent to Ingres SQL without the extensions specific to Ingres®. This guide is designed for programmers who write applications that are portable across all EDBC®, Enterprise Access, and Ingres® servers.

Note: If you are working through an Enterprise Access product, see your Enterprise Access product documentation for information about syntax that may differ from that described in this guide.

Audience

The OpenSQL Reference Guide is intended for programmers and OpenSQL users who have a basic understanding of how Ingres and relational database systems work. In addition, the reader should have a basic understanding of the operating system. This guide is also intended as a reference for the database system administrator.

Conventions
Syntax The following terminology distinctions are made when dealing with language items:
  •   A command is an operation that you execute from an OpenROAD® Development menu or at the operating system level.
  •   A statement is an operation that you place in a program or called procedure. Statements can be written in OpenROAD’s fourth-generation language (4GL), a database query language (such as SQL), or a 3GL (like C or COBOL).

What Is OpenSQL?

SQL (Structured Query Language) is a language that allows you to manipulate and maintain data in a relational database. OpenSQL is a version of SQL that was specifically designed to be compatible across several SQL dialects.

OpenSQL allows you to create applications that run on the following servers:
 
The Ingres DBMS (for Ingres databases)
  •   Enterprise Access products (for access to other database management systems)
  •   Ingres Distributed Option (for distributed databases)
  •   EDBC servers
OpenSQL statements can be used in the following contexts:
 
  •   Terminal Monitor
  •   Embedded OpenSQL programs
  •   Applications built with Vision (a forms-based application development tool)
  •   Applications built with OpenROAD (a graphical user interface application development tool)

Use OpenSQL statements in the interactive Terminal Monitor or in embedded OpenSQL programs. OpenSQL statement syntax and results are consistent across supported host programming languages. This guide does not include specific information about host languages. For details, see the Embedded SQL Companion Guide.

Forms statements allow you to write embedded applications that interact with users through Visual Forms Editor forms. For details about forms statements, see the Forms-based Application Development Tools User Guide.