Contents

Title and Copyright Information

Send Us Your Comments

Preface

Who Should Read This Guide?

Standards Conformance

How the SQL*Module Guide Is Organized

Conventions Used in This Guide

Notation

1 Introduction to SQL*Module

What Is SQL*Module?

Background

Precompilers

The Module Language Concept

SQL*Module as an Interface Builder

What Is Supported by SQL*Module?

What SQL Statements are Not Supported by SQL*Module?

2 Module Language

The Module

An Example Module

A Short Example Program in Ada

Structure of a Module

Preamble

Cursor Declarations

Procedure Definitions

SQL Datatypes

SQL Commands

Text in a Module

Comments

Indicator Parameters

Status Parameters

Error Messages

CONNECT Statement

SET CONNECTION Statement

DISCONNECT Statement

Multi-tasking

ENABLE THREADS

SQL_CONTEXT Datatype

CONTEXT ALLOCATE

CONTEXT FREE

Multi-tasking Restrictions

Multi-tasking Example

3 Accessing Stored Procedures

PL/SQL

Procedures

Stored Procedures

Stored Packages

Accessing Stored Procedures

Case of Package and Procedure Names

Early and Late Binding

Cursor Variables

Cursor Variable Parameters

Allocating a Cursor Variable

Opening a Cursor Variable

Closing a Cursor Variable

Restrictions on Cursor Variables

Dynamic SQL

The WITH INTERFACE Clause

Examples

SQL Datatypes

The Default WITH INTERFACE Clause

Storing Module Language Procedures

Connecting to a Database

4 Developing the Ada Application

Program Structure

Error Handling

SQLCODE

Obtaining Error Message Text

SQLSTATE

Obtaining the Number of Rows Processed

Handling Nulls

Indicator Variables

Cursors

Specification Files

Calling a Procedure

Arrays as Procedure Arguments

National Language Support

5 Running SQL*Module

SQL*Module Input and Output

Input sources

Output Files

Determining the Input Source

Invoking SQL*Module

Running the Compiler

Case Sensitivity in Program Names, Option Names, and Values

Listing Options and Default Values

How to Specify Command-Line Options

Value Lists

Default Values

Configuration Files

Input Files

Output Files

Source Code Output File

Specification File

Listing File

PL/SQL Source Files

Avoid Default Output Filenames

Command-Line Options

AUTO_CONNECT

BINDING

CONFIG

ERRORS

FIPS

INAME

LNAME

LTYPE

MAPPING

MAXLITERAL

ONAME

OUTPUT

PNAME

RPC_GENERATE

SELECT_ERROR

SNAME

STORE_PACKAGE

SQLCHECK

USERID

Compiling and Linking

An Example (Module Language)

6 Demonstration Programs

The SQL_STANDARD Package

SQLCODE

SQLSTATE

Sample Programs

Sample Tables

Module Language Sample Program

Calling a Stored Procedure

Sample Applications

DEMOHOST.A

DEMCALSP.A

A New Features

New Statements

Other New Features

B Module Language Syntax

Module Language Syntax Diagrams

Preamble

Cursors

Procedure Definitions

WITH INTERFACE CLAUSE

C Reserved Words

Module Reserved Words

D SQLSTATE Codes

SQLSTATE Codes

E System-Specific References

System-Specific Aspects of SQL*Module

Supported Compilers

Character Case in Command Lines

Location of Files

Filename Extensions

Ada Output Files

Command Line

Ada SQL_STANDARD Package