Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Command Syntax
• Accessing Documentation
• Related Documentation
• Typographic Conventions

1 Overview of Oracle Database Products

• 1.1 Servers
• 1.2 Tools and Utilities
• 1.3 Networking
• 1.4 Application Development
• • 1.4.1 Access Managers
  • 1.4.2 Oracle Call Interface (OCI) and Oracle C++ Call Interface (OCCI)
• 1.5 Other Software

2 Oracle Software Interaction with z/OS and Language Environment

• 2.1 Overview
• 2.2 Execution Environments on z/OS
• • 2.2.1 POSIX ON vs. POSIX Shell Environments
  • 2.2.2 Runtime Program Access Requirements
  • • 2.2.2.1 Application Program, Tool, or Utility
    • 2.2.2.2 LE Runtime
    • 2.2.2.3 Oracle Program Interface Code
    • 2.2.2.4 Oracle Supporting Data Objects
    • 2.2.2.5 Invocation Examples
  • 2.2.3 Tool and Utility Parameter Conventions
  • • 2.2.3.1 Parameters in Batch (JCL)
    • 2.2.3.2 Parameters in TSO
    • 2.2.3.3 Parameters in a z/OS UNIX Shell
    • 2.2.3.4 Parameters Containing Spaces
  • 2.2.4 Environment Variables
  • • 2.2.4.1 Environment Variables in a z/OS UNIX Shell
    • 2.2.4.2 Environment Variables in Batch and TSO Environments
    • 2.2.4.3 Oracle Environment Variable Files
    • 2.2.4.4 Setting Environment Variables in a Program
• 2.3 Files, File Name Syntax, and File Processing
• • 2.3.1 Filespecs
  • 2.3.2 File Types and Filespec Syntax
  • • 2.3.2.1 Data Set Names
    • 2.3.2.2 DD Names
    • 2.3.2.3 SYSOUT
    • 2.3.2.4 TSO Terminal
    • 2.3.2.5 HFS Files
  • 2.3.3 Standard Files and Redirection
  • • 2.3.3.1 Standard File Defaults (non-POSIX)
    • 2.3.3.2 Redirection Operators in TSO and Batch
  • 2.3.4 File Name Manipulation
  • • 2.3.4.1 What's in a Name?
    • 2.3.4.2 Data Set Name Parts
    • 2.3.4.3 HFS File Name Parts
    • 2.3.4.4 Extension Processing
    • 2.3.4.5 FNA
    • 2.3.4.6 FNA Name Transformation
    • 2.3.4.7 FNA Attribute Assignment
    • 2.3.4.8 Example FNA Control File
  • 2.3.5 Data Set DCB Attributes
  • • 2.3.5.1 Default DCB Attributes
    • 2.3.5.2 DCB Attributes from FNA
    • 2.3.5.3 DCB Attributes without FNA
• 2.4 Interrupt Processing in TSO and z/OS UNIX Shell
• 2.5 Oracle C Runtime Compatibility
• • 2.5.1 Controlling Compatibility
  • 2.5.2 Filespec Compatibility
  • 2.5.3 File Attribute Compatibility
  • 2.5.4 Data Set Name Prefixing Compatibility
  • 2.5.5 Standard Files and Redirection Compatibility

3 Oracle Net and Server Connections on z/OS

• 3.1 Protocols
• • 3.1.1 Protocol and Address Determination
  • 3.1.2 XM Protocol
  • • 3.1.2.1 XM Protocol Address
    • 3.1.2.2 XM Protocol Examples
  • 3.1.3 TCP Protocol
• 3.2 Oracle Net Files
• • 3.2.1 Profile Parameters (sqlnet.ora)
  • • 3.2.1.1 LOG_DIRECTORY_CLIENT
    • 3.2.1.2 LOG_FILE_CLIENT
    • 3.2.1.3 TRACE_DIRECTORY_CLIENT
    • 3.2.1.4 TRACE_FILE_CLIENT
  • 3.2.2 Local Naming Parameters (tnsnames.ora)
  • 3.2.3 Directory Usage Parameters (ldap.ora)
  • 3.2.4 Oracle Net Output Files

4 Oracle Tools and Utilities on z/OS

• 4.1 SQL*Plus
• • 4.1.1 Invocation
  • 4.1.2 Output Interruption
  • 4.1.3 Profile Files
  • 4.1.4 SQL Files
  • 4.1.5 EDIT Command Processing
  • 4.1.6 SPOOL Command Processing
  • 4.1.7 HOST Command Processing
  • 4.1.8 TIMING Processing
  • 4.1.9 Return Codes
  • 4.1.10 Unsupported Features
  • 4.1.11 SQL*Plus Examples
• 4.2 SQL*Loader
• • 4.2.1 Invocation
  • 4.2.2 SQL*Loader Files and Filespecs
  • • 4.2.2.1 Control File
    • 4.2.2.2 Log File
    • 4.2.2.3 Data Files
    • 4.2.2.4 Bad and Discard Files
  • 4.2.3 VSAM Data File Processing Considerations
  • 4.2.4 Bad and Discard File Attributes
  • 4.2.5 SQL*Loader Return Codes
  • 4.2.6 SQL*Loader Examples
• 4.3 Export and Import
• • 4.3.1 Invocation
  • 4.3.2 Export File
  • 4.3.3 Cross-System Export/Import
  • 4.3.4 Export and Import Return Codes
  • 4.3.5 Unsupported Features
  • 4.3.6 Export and Import Examples
• 4.4 Datapump Export and Import
• • 4.4.1 Invocation
  • 4.4.2 Datapump Export and Log Files
  • 4.4.3 Datapump Processing in the Server
  • 4.4.4 Datapump Export and Import Interactive Mode
  • 4.4.5 Datapump Export and Import Return Codes
• 4.5 TKPROF
• • 4.5.1 Invocation
  • 4.5.2 Input Trace File
  • 4.5.3 Output Files
  • 4.5.4 Return Codes
  • 4.5.5 TKPROF Example

5 Oracle Server Considerations on z/OS

• 5.1 Character Data
• • 5.1.1 Character Data and SQL Queries
  • 5.1.2 Character Data and Partitioned Tables
  • 5.1.3 Characters in SQL Statements
• 5.2 File Processing in the Server
• • 5.2.1 Security Considerations
  • 5.2.2 Database Directory Objects
  • 5.2.3 UTL_FILE
  • • 5.2.3.1 UTL_FILE Example
  • 5.2.4 JAVA File I/O
  • 5.2.5 External LOBs (BFILEs)
  • 5.2.6 External Tables
  • 5.2.7 Datapump Export and Import

6 Developing Oracle Applications to Run on z/OS

• 6.1 Overview
• 6.2 Application Design Considerations
• • 6.2.1 Basic Application Requirements
  • 6.2.2 Requirements for Complex Applications
  • • 6.2.2.1 Using z/OS Assembler Language
    • 6.2.2.2 Dynamic Linkage Techniques
    • 6.2.2.3 Multiple LE Enclaves in an Application
    • 6.2.2.4 Multitasking Applications
    • 6.2.2.5 z/OS Environment and z/Architecture Hardware States
    • 6.2.2.6 POSIX Threading
    • 6.2.2.7 OCI Interface to Publish/Subscribe
• 6.3 Building an Application
• • 6.3.1 Precompiling Programs
  • • 6.3.1.1 Oracle Precompiler Executables
    • 6.3.1.2 Oracle Precompiler INCLUDE Files
    • 6.3.1.3 Oracle Precompiler Options
    • 6.3.1.4 Configuration Files
    • 6.3.1.5 Return Codes
    • 6.3.1.6 Language-Specific Coding Considerations
    • 6.3.1.7 Special Considerations for Running Precompilers in Batch and TSO Environments
    • 6.3.1.8 Sample JCL for Running the Pro*C/C++ Precompiler in Batch Environments
    • 6.3.1.9 Sample JCL for Running the Pro*COBOL Precompiler in Batch Environments
    • 6.3.1.10 Sample JCL for Running the Pro*FORTRAN Precompiler in Batch Environments
    • 6.3.1.11 Sample JCL for Running the Pro*PL/I Precompiler in Batch Environments
    • 6.3.1.12 Sample Commands for Running Oracle Precompilers in a Shell
  • 6.3.2 Compiler Options for Oracle Applications
  • • 6.3.2.1 C/C++ Compiler Options
    • 6.3.2.2 COBOL Compiler Options
    • 6.3.2.3 PL/I Compiler Options
  • 6.3.3 Compiling Programs
  • • 6.3.3.1 Sample Commands for Compiling Programs in a Shell
    • 6.3.3.2 Compiling OCCI programs to Run in Batch and TSO Environments
  • 6.3.4 Linking Programs
  • • 6.3.4.1 Linking Pro*C/C++, OCI, COBOL, and PL/I Programs to Run in Batch and TSO Environments
    • 6.3.4.2 Linking COBOL Programs Using DYNAM
    • 6.3.4.3 Linking FORTRAN programs to Run in Batch and TSO Environments
    • 6.3.4.4 Linking API Stub Programs to Run in a Shell
    • 6.3.4.5 Sample Commands for Compiling and Linking API Stub Programs in a Shell
    • 6.3.4.6 Linking DLL Stub Programs in a Shell
    • 6.3.4.7 Sample Commands for Compiling and Linking DLL Stub Programs in a Shell
    • 6.3.4.8 Binding OCCI programs to Run in Batch and TSO Environments
    • 6.3.4.9 Building an Oracle XDK API Using Program in a Shell
  • 6.3.5 Using Oracle-Supplied Procedures to Build Applications
  • • 6.3.5.1 Sample Batch JCL to Build an Oracle Precompiler Program
    • 6.3.5.2 Using Make to Build a Precompiler Program
    • 6.3.5.3 Pro*COBOL Sample Programs
    • 6.3.5.4 Pro*FORTRAN Sample Programs
    • 6.3.5.5 Pro*C/C++ Sample Programs
    • 6.3.5.6 Batch JCL to Build OCI Programs
    • 6.3.5.7 Batch JCL to Build OCCI Programs
    • 6.3.5.8 Using Make to Build OCI and OCCI Programs
    • 6.3.5.9 Sample OCI and OCCI Programs
• 6.4 Building a Traditional Load Module with the Alternate API Stub
• • 6.4.1 Method 1: Prelink and Link
  • 6.4.2 Method 2: Precompile and/or Compile with Name Mapping
  • 6.4.3 Method 3: Link
• 6.5 Application Runtime Considerations
• • 6.5.1 Oracle Interface Initialization, Processing, and Error Handling
  • 6.5.2 Application Resources and Cleanup
• 6.6 Developing Oracle Applications for the CICS TS Environment
• • 6.6.1 CICS TS Application Design Considerations
  • • 6.6.1.1 CICS TS Versions Supported
    • 6.6.1.2 CONNECT Statements
    • 6.6.1.3 Synchronization of Oracle and CICS TS Updates
    • 6.6.1.4 Cursor Considerations
    • 6.6.1.5 Accessing Multiple Oracle Databases
    • 6.6.1.6 Accessing Oracle Database 10g and DB2 Databases in a Single Transaction
    • 6.6.1.7 Additional SQL Statement Restrictions
  • 6.6.2 CICS TS EDF and Oracle SQL Statements
  • 6.6.3 Environment Variables
  • 6.6.4 Considerations for Building a CICS TS application
  • 6.6.5 Running CICS TS Programs
• 6.7 Developing Oracle Applications for the IMS TM Environment
• • 6.7.1 IMS TM Application Design Considerations
  • • 6.7.1.1 IMS TM Versions Supported
    • 6.7.1.2 CONNECT Not Supported
    • 6.7.1.3 Synchronization of Oracle and IMS TM Updates
    • 6.7.1.4 Cursor Considerations
    • 6.7.1.5 Accessing Multiple Oracle Databases
    • 6.7.1.6 Additional SQL Statement Restrictions
    • 6.7.1.7 Accessing Oracle Database 10g and DB2 Databases in a Single Transaction
    • 6.7.1.8 Processing of Oracle Database 10g Errors by Your IMS TM Program
  • 6.7.2 Environment Variables
  • 6.7.3 Considerations for Building an IMS TM application
  • 6.7.4 Running IMS TM Programs

7 Migration from Earlier Oracle Versions

• 7.1 Overview
• 7.2 Migrating from Oracle8i
• • 7.2.1 Migration Checklist
• 7.3 Migrating from Oracle9i
• • 7.3.1 Normalized File Access
  • 7.3.2 Global Environment File
  • 7.3.3 Use of LE Exit CEEBXITA
  • 7.3.4 Oracle Runtime Compatibility
  • 7.3.5 SYSOUT Filespec in Clients
  • 7.3.6 SQL*Loader Changes
  • • 7.3.6.1 Interpretation of DDN Keywords
    • 7.3.6.2 Default Filespecs for DD-type Data Files
    • 7.3.6.3 Default Filespecs for Data Set Name Files
    • 7.3.6.4 Default Bad/Discard DCB attributes

A Environment Variables Used by Oracle Database for z/OS

• A.1 Environment Variables Used by Oracle Database

Index