Contents

Title and Copyright Information

Send Us Your Comments

Preface

Intended Audience

Structure

Related Documents

Product Name

SQL*Plus Prompts

Storage Measurements

Conventions

Switches

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

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 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 Accessed Through CLISTs

Submitting a Batch Job

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

Oracle Standard Files

Redirecting Standard Files and Parameters

Filetype Suffixes

File Name/Attribute Augmentation (FNA) Facility

FNA Controls and Operations

FNA File Name Construction

FNA Example

Default FSA Entry

User-Defined FNA Control Files

Specifying an FNA Control File

Creating an FNA Control File

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

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

IMS TM Programs

Sample JCL

Precompiling Your Program

Oracle Precompiler Options

Return Codes

Language-Specific Coding Considerations

Compiling Your Program

CICS Programs

Linking Your Program

Batch and TSO Programs

CICS Programs

IMS TM Programs

Running Your Program

UNIX System Services

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

Compiling Your Program

Long Name Support

Callback Restriction

UNIX System Services

Linking Your Program

Sample Link JCL

Batch and TSO Programs

CICS Programs

IMS TM Programs

Running Your Program

Batch and TSO Programs

CICS 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

Return Codes from the SQL*Plus HOST Command

SQL*Plus Time Usage Information

TIMING Command

SET TIMING Command

Using OS/390 Editors from SQL*Plus

TSO Editor

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 and OS/390 Clients

Oracle Net for OS/390 Filenames

Locating the Oracle Net Service

Oracle Net Connect Descriptors for OS/390

Examples

11 Migration Considerations

Overview

OS/390 Client Applications

Access Manager for IMS

Split Vertical Bar Support

CMDLOAD and JCL Considerations

OS/390 Clients

Cross Memory Support

TNSNAMES Connect Descriptors

Database Links

IXCF Support

USS Applications and Tools

Remote Clients

Index