Skip Headers

Oracle9i Enterprise Edition User's Guide
Release 2 (9.2.0.1.0) for OS/390
Part No. A97312-01
Go To Index
Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Structure
Related Documents
Product Name
Tool and Utility Prompts
Storage Measurements
Conventions
Documentation Accessibility
Documents Referenced in this Guide

1 Overview of Oracle9i Products

Oracle9i for OS/390 Introduction
Real Application Clusters
Oracle Label Security
Oracle Spatial
Oracle Partitioning
Oracle Advanced Security
High-Performance Concurrency Control
Web Integration
SQL and PL/SQL Languages
Application Development
Server-Based Business Rules
National Language Support
Data Replication in Distributed Environments
Advanced Queuing
Oracle Objects
Oracle Call Interface
Oracle for OS/390 Java Support
Java Database Connectivity (JDBC)
SQL Embedded in Java (SQLJ)
Oracle9i JVM
XML Support
Oracle9i for OS/390 Utilities
Recovery Manager
Export and Import
Migration
SQL*Loader
Oracle Enterprise Manager
UNIX System Services
Oracle9i for OS/390 Additional Products
Oracle Access Managers
Oracle Access Manager for CICS
Oracle Access Manager for IMS TM
Oracle Precompilers
Oracle Net
SQL*Plus
Oracle9i for OS/390 Transparent Gateways
Oracle Transparent Gateway for DB2
Oracle Transparent Gateway for EDA/SQL 

2 Using the OS/390 Database Instance

Oracle Database Instance Overview
Connecting to an Oracle Instance
Enabling OS/390 Local Client Access
Cross-Memory Protocol Address
Specifying Connections
Installation Information
Oracle9i Server and Library Names
Tool Syntax and Batch Procedures
OS/390 Features
Using Oracle Utilities
Invoking Oracle Utilities from TSO
Oracle Utilities as Command Processors
Oracle Utilities as CALL Programs
Oracle Utilities Accessed Through CLISTs
Submitting a Batch Job
Sample Cataloged Procedure
Sample Batch Job
Using the Batch TMP
Exiting Utilities and Utilities in TSO
Attention Processing
OS/390 Environment Variables

3 Oracle9i Utilities and OS/390 Files

Using OS/390 Files
General Notation for Specifying Files
File Specification Types
Summary of Filespecs
Specifying Files by DDname (/DD/ )
Specifying Files by Full Data Set Name (/DSN/)
Specifying Files by Unqualified Data Set Name
Redirecting Standard Files and Parameters
Redirecting Files
Redirecting Parameters
Filetype Suffixes
File Name/Attribute Augmentation (FNA) Facility
FNA Controls and Operations
FSA Table
FNA File Name Construction
Substitution
Construction Procedure
FNA Example
Default FSA Entry
User-Defined FNA Control Files
Specifying an FNA Control File
Creating an FNA Control File
FSA Entries
Attribute Keywords
FNA Control File Error Handling
FSA Keyword Usage Notes
Examples Using FNA

4 Accessing Oracle9i Under USS

OS/390 UNIX System Services Overview
Oracle Database Instance Overview
Connecting to an Oracle Instance
Enabling OS/390 Local Client Access
Cross-Memory Protocol Address
Specifying Connections
Storing Connection Information
Break Processing
Running an Oracle Utility on OS/390 Under USS
Environment Variables
File Names in OS/390 UNIX System Services
Accessing OS/390 Data Sets
Utilities Available Under OS/390 USS
PL/SQL Wrapper
PL/SQL Server Page Loader
Data Guard Command-line Utility
OEM Intelligent Agent and Data Gatherer
Oracle JDBC Thin Driver
SQLJ Translator
Loadjava/Dropjava Utilities
Oracle Wallet Manager
TNSPING
Character Set Scanner
Locale Builder
Customer-Written Applications Under USS
Child Process Restrictions
POSIX Thread Support

5 Export and Import Utilities

Export
Running Under UNIX System Services
Running Under TSO
Running in Batch
Return Codes
Exporting to Non-OS/390 Systems
Import
Running Under UNIX System Services
Running Under TSO
Running in Batch
Return Codes
Importing from Non-OS/390 Systems

6 SQL*Loader

Running Under UNIX System Services
Running Under TSO
SQL*Loader Files
SQL*Loader File Names
SQL*Loader File Attributes
Running in Batch
Return Codes
SQL*Loader VSAM File Support
Specifying VSAM Input to SQL*Loader
SQL*Loader VSAM Processing Considerations
BAD and DISCARD File Considerations with VSAM Input
SQL*Loader Direct Path
Performance

7 Oracle Precompilers

Oracle Precompilers Overview
Target Environment Design Considerations
TSO Programs
CICS Programs
Use of CONNECT...AT
Synchronization of Oracle and CICS Updates
Passing Control with CICS LINK or XCTL Commands
Explicitly Opened Cursors
Accessing Multiple Oracle9i Databases
Additional SQL Statement Restrictions
IMS TM Programs
CONNECT Not Supported
Accessing Multiple Oracle9i Databases
Additional SQL Statement Restrictions
Accessing Oracle9i and DB2 Databases in a Single Transaction
Controlling Oracle SQL Processing
Processing of Oracle9i Errors by Your IMS TM Program
Sample JCL
Usage Notes
Precompiling Your Program
Oracle Precompiler Options
Return Codes
Language-Specific Coding Considerations
Compiler Support
Pro*COBOL
Pro*C
Pro*PL/1
Compiling Your Program
CICS Programs
Linking Your Program
Batch and TSO Programs
CICS Programs
IMS TM Programs
Running Your Program
UNIX System Services
Administering Pro*COB Under UNIX System Services
Administering Pro*C Under UNIX System Services
Building Pro*C Programs
Sample Programs
Batch and TSO Programs
CICS Programs
IMS TM Programs

8 Oracle Call Interface

Oracle Call Interface Overview
Target Environment Design Considerations
TSO Programs
CICS Programs
IMS TM Programs
Accessing Multiple Oracle9i Databases
Additional Restricted OCI Functions
Unavailable Calls
Accessing Oracle9i and DB2 Databases in a Single Transaction
Processing of Oracle9i Errors by Your IMS TM Program
Compiling Your Program
Long Name Support
Callback Restriction
UNIX System Services
Linking Your Program
Sample Link JCL
Usage Notes
Batch and TSO Programs
IMS TM Programs
Running Your Program
Batch and TSO Programs
IMS TM Programs
OCI Interface to Publish/Subscribe

9 SQL*Plus

Running Under UNIX System Services
Running Under TSO
Attention Processing
Processing States
Batch Processing
Running in Batch
SQL*Plus Profiles
SQL*Plus HOST Command
Running TSO/E Commands
Calling CLISTs
Calling OS/390 Editors
Multiple SQL*Plus Processes
SQL*Plus Time Usage Information
TIMING Command
SET TIMING Command
Using OS/390 Editors from SQL*Plus
ISPF Editor
Data Set Enqueuing
Restricting User's Privileges in SQL*Plus
Exiting SQL*Plus
Spooling SQL*Plus Output
Usage Notes
Special Characters
String Concatenation
Input Line Truncation
SQL ASCII Function
Unsupported Functions
SPOOL OUT
SET NEWPAGE 0
RUNFORM

10 Oracle Net

Oracle Net Overview
Distributed Processing
Distributed Database
Oracle Net Terminology
Remote Access to OS/390 Server Using Oracle Net
Oracle Net for OS/390 Filenames
Locating the Oracle Net Service
Oracle Net Connect Descriptors for OS/390
TCP/IP Addresses
Examples
Connecting to a Remote Server Using Oracle Net

11 Migration Considerations

Overview
OS/390 Language Environment
OS/390 Cross Memory Support
Cross Memory Support
MPM Compatibility
TNSNAMES Connect Descriptors
Database Links
IXCF Support
Remote Clients

A API Short Name Support

Method 1: Prelink and Link
Method 2: Precompile and/or Compile with Name Mapping

Index


Next
Oracle Logo
Copyright © 2002 Oracle Corporation

All rights reserved
Go To Index
Index