2.3 Getting the Full Text of Error Messages

2.4 Using the WHENEVER Statement

2.4.1 Scope of WHENEVER

2.4.1.1< /span> Helpful Hint

2.4.1.2 Caution

2.5 Using the ORACA

< span class="secnum">2.5.1 Declaring the ORACA

2.5.2 Enabl ing the ORACA

2.5.3 What's in the ORACA?

3 Running the Pro*PL/1 Precomp iler

3.1 Precompiler Command

3.2 Precompiler Options

3.2.1 Default Values

3.2.1.1 Determini ng Current Values

3.2.2 Case Sensitivity

3.2.3 Configuration Files

3.2.4 Scope of Options

3.2.5 DBMS

3.2.6 MODE

3.2 .7 Entering Options

3.2.8 Special PL/1 Options

3.3 Doing Conditional Precompilations

3.4 Doing Separate Precompilations

3.4.1 Restrictions

3.5 Compili ng and Linking

4 S ample Programs

4.1 Sample Programs

4.2 Sample Program 1: Login and Query

~~4.3 Sample Program 2: Using a Cursor~~

4.4 Sample Program 3: Fetching in Batches

4.5 Sample Program 4: D atatype Equivalencing

4.6 Sample Program 5: A SQL*Forms User Exi t

4.7 Sample Program 6: Dynamic SQL Method 1

4.8 Sample Program 7: Dynamic SQL Method 2

4.9 Sample Program 8: Dynamic SQL Method 3

4.10 Sample Program 9: Calling a Stored procedure

5 Implementing Dynamic SQL Method 4

5.1 Meeting the Special Requirements of Method 4

5.1.1 What Makes Method 4 Special?

5.1.2 Wha t Information Does Oracle Need?

5.1.3 Where Is the Information S tored?

5.1.4 How is the Information Obtained?

5.2 The SQLDA

5.2.1 Introducing the PL/1 SQLDA

5.2.2 Decl aring a SQLDA

5.2.3 Multiple SQLDAs

5.2.4 The SQLDA Variables

5.2.4.1 {SELDSC | BNDDSC}

5.2.4.2 SQLDNUM

5.2.4.3 SQLDFND

5.2.4.4 SQLDSC(N)

5.2.4.5 SQLDV

5.2.4.6 SQLDFMT

5.2.4. 7 SQLDVLN

5.2.4.8 SQLDVTYP

5.2.4.9 SQLDI

5.2.4.10 SQ LDH_VNAME

5.2.4.11 SQLDH_MAX_VNAMEL

5.2.4.12 SQLDH_CUR_VNAMEL

5.2. 4.13 SQLDI_VNAME

5.2.4.14 SQLDI_MAX_VNAMEL

< a href="ch5.htm#sthref424">5.2.4.15 SQLDI_CUR_VNAMEL

5.2.4.16 SQLDFCLP

5.2.4.17 SQLDFCRCP

5.2.5 Datatypes in the SQLDA

5.2.5.1 Internal and External Datatypes

5.2.5.2 Coercing Datatypes After DESCRIBE

5.2.5.3 Extracting Precision and Scale

5.2.5.4 Datatype Codes< /dd>

5.2.6 Handling NULL/NOT NULL Datatypes

5.3 The Basic Steps

5.4 A Closer Look at Each Step

5.4.1 D eclare a Host String

5.4.2 Set the Size of the Descriptors
5.4.3 Declare the SQLDAs

5.4.4 Declare the Data Buffers

5.4.5 In itialize the Descriptors

5.4.6 Get the Query Text into the Host String

5.4.7 PREPARE the Query from the Host String

5.4.8 DECLARE a Cursor

5.4.9 DESCRIBE the Bind Variables

5.4.10 Variabl esReset Maximum Number of Bind

5.4.11 Get Values for Bind Variab les

5.4.12 OPEN the Cursor

5.4.13 DESCRIBE the SelectList

5.4.14 Adjust the Select Descriptor Values

5.4.15 FETCH A Row fro m the Active Set

5.4.16 Process the Select-List Items
< dd>5.4.17 CLOSE the Cursor

5.5 Using Host Arrays

5.6 Sample 10 : Dynamic SQL Method 4 Program

A Differences from Previous Release

A.1 Topics

B Operat ing System Dependencies

B.1 Topics

Index

Contents

List of Figures

List of Tables

Title and Copyright In formation

Send Us Your Comments

Preface

1 Writing a Pro*PL/1 Program

2 Error Handling and Diagnostics

3 Running the Pro*PL/1 Precomp iler

4 S ample Programs

5 Implementing Dynamic SQL Method 4

A Differences from Previous Release

B Operat ing System Dependencies

Index