Go to main content
1/13
Contents
List of Tables
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.1.5
TNSPING.TRACE_DIRECTORY
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
CONNECT Statements
6.6.1.2
Synchronization of Oracle and CICS TS Updates
6.6.1.3
Cursor Considerations
6.6.1.4
Accessing Multiple Oracle Databases
6.6.1.5
Accessing Oracle Database 10
g
and DB2 Databases in a Single Transaction
6.6.1.6
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 10
g
and DB2 Databases in a Single Transaction
6.7.1.8
Processing of Oracle Database 10
g
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 Oracle8
i
7.2.1
Migration Checklist
7.3
Migrating from Oracle9
i
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
Scripting on this page enhances content navigation, but does not change the content in any way.