Contents

List of Figures

Li st of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Intende d Audience

Documentation Accessibility

Standard s 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

< /dl>

2.2.2 Cursor Declarations

2.2.3 Procedure Definitions

2.2 .3.1 Procedure Name

2.2.3.2 Parameter List

< a href="ch2.htm#sthref104">2.2.3.3 SQL92 Syntax

2.3 SQL Datatypes

2.4 SQL Comman ds

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 SQ L_CONTEXT Datatype

2.10.3 CONTEXT ALLOCATE

2.10.4 CONTEXT FREE

2.1 0.5 Multi-tasking Restrictions

2.11 Multi-taski ng Example

3 Acces sing Stored Procedures

3.1.1 Procedures

3.2 Stored Procedures

3.3 Stored Package s

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 Type s

3.7.4 Closing a Cursor Variable

3.7.5 Restrictions on Cursor Variables

3.8 Dynamic SQL

3.9 The WITH I NTERFACE Clause

3.9.2 SQL Datatypes

3.9.2.1 DATE Datatype

3.9.3 The Default WI TH INTERFACE Clause

3.9.3.1 Procedures

3.9.3.2 Functions

3.10 Storing Module Language Procedures

3.1 1 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.5 Cursors< /dd>

4.6 Specification Files

4.7 Calling a Procedure

4.8 Arrays as P rocedure Arguments

4.9 National Language Support

< h3>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 Defa ult 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_CON NECT

< a href="ch5.htm#sthref368">5.8.5 FIPS

5.8.10 MAXLITERAL

5.8.14 RPC_GENERATE

5.8.15 SELECT_ERROR

5.8.17 ST ORE_PACKAGE

5.8.18 SQLCHECK

5.9 Com piling and Linking

5.9.1 An Example (Module Language)< /a>

6 Demon stration Programs

6.1 The SQL_STANDARD Package

6.2 Sample Prog rams

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 DEMOHO ST.A

6.3.2 DEMCALSP.A

A New Features

A.1 New Statements

A.2< /span> Other New Features

B Module Language Syntax

B.1 Module Languag e Syntax Diagrams

< dd>B.1.1.1 LANGUAGE Clause

B.1.1.2 AUTHORIZATION Clause

B.1.3 Procedure Definitions

< a href="appb.htm#sthref462">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-Spec ific Aspects of SQL*Module

E.1.1 Supported Compilers< /a>

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