Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Standards Conformance

Related Documents

1 Introduction to SQL*Module

1.1 What Is SQL*Module?

1.1.1 Background

1.1.2 Precompilers

1.1.3 The Module Language Concept

1.2 SQL*Module as an Interface Builder

1.3 What Is Supported by SQL*Module?

1.4 What SQL Statements are Not Supported by SQL*Module?

2 Module Language

2.1.1 An Example Module

2.1.2 A Short Example Program in Ada

2.2 Structure of a Module

2.2.1.1 MODULE Clause

2.2.1.2 LANGUAGE Clause

2.2.1.3 AUTHORIZATION Clause

2.2.2 Cursor Declarations

2.2.3 Procedure Definitions

2.2.3.1 Procedure Name

2.2.3.2 Parameter List

2.2.3.3 SQL92 Syntax

2.3 SQL Datatypes

2.4 SQL Commands

2.5 Text in a Module

2.6 Indicator Parameters

2.7 Status Parameters

2.7.1 Error Messages

2.8 CONNECT Statement

2.8.1 SET CONNECTION Statement

2.9 DISCONNECT Statement

2.10 Multi-tasking

2.10.1 ENABLE THREADS

2.10.2 SQL_CONTEXT Datatype

2.10.3 CONTEXT ALLOCATE

2.10.4 CONTEXT FREE

2.10.5 Multi-tasking Restrictions

2.11 Multi-tasking Example

3 Accessing Stored Procedures

3.1.1 Procedures

3.2 Stored Procedures

3.3 Stored Packages

3.4 Accessing Stored Procedures

3.5 Case of Package and Procedure Names

3.6 Early and Late Binding

3.7 Cursor Variables

3.7.1 Cursor Variable Parameters

3.7.2 Allocating a Cursor Variable

3.7.3 Opening a Cursor Variable

3.7.3.1 Opening in a Stand-alone Stored Procedure

3.7.3.2 Return Types

3.7.4 Closing a Cursor Variable

3.7.5 Restrictions on Cursor Variables

3.8 Dynamic SQL

3.9 The WITH INTERFACE Clause

3.9.2 SQL Datatypes

3.9.2.1 DATE Datatype

3.9.3 The Default WITH INTERFACE Clause

3.9.3.1 Procedures

3.9.3.2 Functions

3.10 Storing Module Language Procedures

3.11 Connecting to a Database

4 Developing the Ada Application

4.1 Program Structure

4.2 Error Handling

4.2.2 Obtaining Error Message Text

4.3 Obtaining the Number of Rows Processed

4.4 Handling Nulls

4.4.1 Indicator Variables

4.6 Specification Files

4.7 Calling a Procedure

4.8 Arrays as Procedure Arguments

4.9 National Language Support

5 Running SQL*Module

5.1 SQL*Module Input and Output

5.1.1 Input sources

5.1.2 Output Files

5.1.3 Determining the Input Source

5.2 Invoking SQL*Module

5.2.1 Running the Compiler

5.3 Case Sensitivity in Program Names, Option Names, and Values

5.3.1 Listing Options and Default Values

5.4 How to Specify Command-Line Options

5.4.1 Value Lists

5.4.2 Default Values

5.5 Configuration Files

5.6 Input Files

5.7 Output Files

5.7.1 Source Code Output File

5.7.1.1 Default File Names for Ada

5.7.2 Specification File

5.7.2.1 Default Specification Filenames for Ada

5.7.3 Listing File

5.7.4 PL/SQL Source Files

5.7.5 Avoid Default Output Filenames

5.8 Command-Line Options

5.8.1 AUTO_CONNECT

5.8.10 MAXLITERAL

5.8.14 RPC_GENERATE

5.8.15 SELECT_ERROR

5.8.17 STORE_PACKAGE

5.8.18 SQLCHECK

5.9 Compiling and Linking

5.9.1 An Example (Module Language)

6 Demonstration Programs

6.1 The SQL_STANDARD Package

6.2 Sample Programs

6.2.1 Sample Tables

6.2.1.1 MKTABLES.SQL

6.2.1.2 DEPARTMT.SQL

6.2.1.3 INSTRUCS.SQL

6.2.1.4 STUDENTS.SQL

6.2.1.5 COURSES.SQL

6.2.1.6 EMROLMNT.SQL

6.2.2 Module Language Sample Program

6.2.3 Calling a Stored Procedure

6.3 Sample Applications

6.3.1 DEMOHOST.A

6.3.2 DEMCALSP.A

A New Features

A.1 New Statements

A.2 Other New Features

B Module Language Syntax

B.1 Module Language Syntax Diagrams

B.1.1.1 LANGUAGE Clause

B.1.1.2 AUTHORIZATION Clause

B.1.3 Procedure Definitions

B.2 WITH INTERFACE CLAUSE

C Reserved Words

C.1 Module Reserved Words

D SQLSTATE Codes

D.1 SQLSTATE Codes

E System-Specific References

E.1 System-Specific Aspects of SQL*Module

E.1.1 Supported Compilers

E.1.2 Character Case in Command Lines

E.1.3 Location of Files

E.1.4 Filename Extensions

E.1.5 Ada Output Files

E.1.6 Command Line

E.1.7 Ada SQL_STANDARD Package

Index