Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Documentation Accessibility

Related Documents

Storage Measurements

1 Overview of Oracle 10g Products on z/OS

Tools and Utilities

Application Development

Access Managers

Oracle Call Interface

2 Oracle Software Interaction with z/OS and Language Environment

Execution Environments on z/OS

POSIX ON vs. POSIX Shell Environments

Runtime Program Access Requirements

Application Program, Tool, or Utility

Oracle Program Interface Code

Oracle Supporting Data Objects

Invocation Examples

Tool and Utility Parameter Conventions

Parameters in Batch (JCL)

Parameters in TSO

Parameters in a z/OS UNIX Shell

Parameters Containing Spaces

Environment Variables

Environment Variables in a z/OS UNIX Shell

Environment Variables in Batch and TSO Environments

Oracle Environment Variable Files

Setting Environment Variables in your Program

Files, File Name Syntax, and File Processing

File Types and Filespec Syntax

Standard Files and Redirection

Standard File Defaults (non-POSIX)

Redirection Operators in TSO and Batch

File Name Manipulation

What's in a Name?

Data Set Name Parts

HFS File Name Parts

Extension Processing

FNA Name Transformation

FNA Attribute Assignment

Example FNA Control File

Data Set DCB Attributes

Default DCB Attributes

DCB Attributes from FNA

DCB Attributes without FNA

Interrupt Processing in TSO and z/OS UNIX Shell

Oracle C Runtime Compatibility

Controlling Compatibility

Filespec Compatibility

File Attribute Compatibility

Data Set Name Prefixing Compatibility

Standard Files and Redirection Compatibility

3 Oracle Net and Server Connections on z/OS

Protocol and Address Determination

XM Protocol Address

XM Protocol Examples

Oracle Net Files

Profile Parameters (sqlnet.ora)

LOG_DIRECTORY_CLIENT

LOG_FILE_CLIENT

TRACE_DIRECTORY_CLIENT

TRACE_FILE_CLIENT

Local Naming Parameters (tnsnames.ora)

Directory Usage Parameters (ldap.ora)

Oracle Net Output Files

4 Oracle Tools and Utilities on z/OS

Output Interruption

EDIT Command Processing

SPOOL Command Processing

HOST Command Processing

TIMING Processing

Unsupported Features

SQL*Plus Examples

SQL*Loader Files and Filespecs

Bad and Discard Files

VSAM Data File Processing Considerations

Bad and Discard File Attributes

SQL*Loader Return Codes

SQL*Loader Examples

Export and Import

Cross-System Export/Import

Export and Import Return Codes

Unsupported Features

Export and Import Examples

Datapump Export and Import

Datapump Export and Log Files

Datapump Processing in the Server

Datapump Export and Import Interactive Mode

Datapump Export and Import Return Codes

Input Trace File

5 Oracle Server Considerations on z/OS

Character Data and SQL Queries

Character Data and Partitioned Tables

Characters in SQL Statements

File Processing in the Server

Security Considerations

Database Directory Objects

UTL_FILE Example

External LOBs (BFILEs)

External Tables

Datapump Export and Import

6 Developing Oracle Applications to Run on z/OS

Application Design Considerations

Basic Application Requirements

Requirements for Complex Applications

Using z/OS Assembler Language

Dynamic Linkage Techniques

Multiple LE Enclaves in an Application

Multitasking Applications

z/OS Environment and z/Architecture Hardware States

POSIX Threading

OCI Interface to Publish/Subscribe

Building an Application

Precompiling Your Programs

Oracle Precompiler Executables

Oracle Precompiler INCLUDE Files

Oracle Precompiler Options

Configuration Files

Language-Specific Coding Considerations

Special Considerations for Running Precompilers in Batch and TSO Environments

Sample JCL for Running the Pro*C Precompiler in Batch Environments

Sample JCL for Running the Pro*COBOL Precompiler in Batch Environments

Sample JCL for Running the Pro*PL/I Precompiler in Batch Environments

Sample Commands for Running Oracle Precompilers in a Shell

Compiler Options for Oracle Applications

C/C++ Compiler Options

COBOL Compiler Options

PL/I Compiler Options

Compiling Your Programs

Sample Commands for Compiling Programs in a Shell

Linking Your Programs

Linking Programs to Run in Batch and TSO Environments

Linking COBOL Programs Using DYNAM

Linking Programs to Run in a Shell

Sample Commands for Compiling and Linking Programs in a Shell

Using Oracle-Supplied Procedures to Build Applications

Sample Batch JCL to Build an Oracle Precompiler Program

Using Make to Build a Precompiler Program

Pro*COBOL Sample Programs

Pro*C Sample Programs

Batch JCL to Build an OCI Program

Using Make to Build an OCI Program

Sample OCI Programs

Building a Traditional Load Module with the Alternate API Stub

Method 1: Prelink and Link

Method 2: Precompile and/or Compile with Name Mapping

Application Runtime Considerations

Oracle Interface Initialization, Processing, and Error Handling

Application Resources and Cleanup

Developing Oracle Applications for the CICS TS Environment

CICS TS Application Design Considerations

CICS TS Versions Supported

CONNECT Statements

Synchronization of Oracle and CICS TS Updates

Cursor Considerations

Accessing Multiple Oracle Databases

Accessing Oracle Database 10g and DB2 Databases in a Single Transaction

Additional SQL Statement Restrictions

CICS TS EDF and Oracle SQL Statements

Environment Variables

Considerations for Building a CICS TS application

Running CICS TS Programs

Developing Oracle Applications for the IMS TM Environment

IMS TM Application Design Considerations

IMS TM Versions Supported

CONNECT Not Supported

Synchronization of Oracle and IMS TM Updates

Cursor Considerations

Accessing Multiple Oracle Databases

Additional SQL Statement Restrictions

Accessing Oracle Database 10g and DB2 Databases in a Single Transaction

Processing of Oracle Database 10g Errors by Your IMS TM Program

Environment Variables

Considerations for Building an IMS TM application

Running IMS TM Programs

7 Migration from Earlier Oracle Versions

Migrating from Oracle8i

Migration Checklist

Migrating from Oracle9i

Normalized File Access

Global Environment File

Use of LE Exit CEEBXITA

Oracle Runtime Compatibility

SYSOUT Filespec in Clients

SQL*Loader Changes

Interpretation of DDN Keywords

Default Filespecs for DD-type Data Files

Default Filespecs for Data Set Name Files

Default Bad/Discard DCB attributes

A Environment Variables Used by Oracle Database for z/OS

Environment Variables Used by Oracle Database for z/OS

Index