Contents

Title and Copyright Information

Send Us Your Comments

Preface

Using Oracle Server Documentation

How this Manual is Organized

Conventions Used in this Manual

Documentation Accessibility

1 Getting Started

The Oracle Server Environment-Definition File

Generating Your Environment-Definition File

Calling Your Environment-Definition File

Specifying the Environment Variables

The ORALOAD Library

Invoking Oracle Utilities with /START-PROGRAM

Invoking Oracle Utilities in Unix Style

Connecting to the Oracle Server

Default Connections

Connecting to the Oracle Server

Using BS2000 Files for Input and Output

Text Files

Binary Files

Generic Oracle Server Filename Syntax

Default File Name Extensions

Using Linknames

Fixed linknames

2 Oracle Server Utilities

SQL*Loader

Invoking the SQL*Loader Utility

Using the SQL*Loader Demonstration Files

The Export Utility

Invoking the Export Utility

Exporting to Foreign Systems

Transferring Data by Tape

Transferring Data by File Transfer

The Import Utility

Invoking the Import Utility

Importing from Foreign Systems

Import File Blocksize

Transferring Data by Tape

Transferring Data by File Transfer

Oracle Text Loader

3 SQL*Plus

Running SQL*Plus

SQL*Plus User Profiles

The GLOGIN.SQL Global Startup File

The LOGIN.SQL User Startup File

Invoking SQL*Plus

Interrupting SQL*Plus

Issuing BS2000 Commands from SQL*Plus

Invoking the BS2000 Editor

The SQL ASCII Function

Spooling SQL*Plus Output

Using SQL*Plus Symbols

SQL*Plus Timing Displays

Specifying the Search Path for SQL*Plus Command Files

SQL*Plus Demonstration Files

SQL*Plus Limits

4 PL/SQL

PL/SQL Demonstrations

PL/SQL Demos for the Kernel

PL/SQL Demos for Precompilers

5 Programmatic Interfaces

Overview

Architecture of the Programmatic Interfaces

PL/SQL

Building and Executing a Programmatic Interface Application

Existing Applications

Precompilers

Include Files

User-Specific Configuration Files

Input-, Output-, and List-files

Additional Remarks

Pro*C/C++

Invoking Pro*C

Pro*C Include, System Configuration and Demo Files

SQLLIB Calls

Linking Pro*C

The Pro*C SQLCPR.H Header File

UTM Applications

Pro*COBOL

Invoking Pro*COBOL

Pro*COBOL Include, System Configuration, and Demo Files

SQLLIB Calls

Linking Pro*COBOL

openUTM Applications

The Oracle Call Interface

Linking OCI

Data Areas and Data Types

The Cursor Data Area

Binary Integers

Short Binary Integers

Optional Parameters

The Object Type Translator

Invoking Ott8

Ott8 System Configuration and Demo Files

6 Using the Oracle Server Under openUTM

SQL Operations

CONNECT

COMMIT

ROLLBACK

SAVEPOINT

Cursor Operations

Dynamic SQL

PL/SQL

Autocommit

UTM Operations

RSET and PEND RS

PEND ER and PEND FR

PEND KP, PEND PR and PEND PA

PEND RE, PEND FI, PEND SP and PEND FC

7 National Language Support

Specifying a Language, Territory and Character Set

Oracle Server

Other Oracle Server Products

Supported Language Conventions

Supported Territories

Supported Character Sets

Location of Message Files

Linguistic Definitions

A Oracle Messages

B ORAENV Variables

ORAENV Rules

Built-in Variables

LOGNAME

ORAUID

PGM

TERM

TSN

General Variables

DEFAULT_CONNECTION

EXP_CLIB_FILE_IO

IMP_CLIB_FILE_IO

IMP_USERID_IGNORE

NLS_LANG

OPS_JID

ORADUMP

ORASID

PRINTPAR

SQLPATH

SSSIDPWF

DBA Startup Variables

Address and Size Specification

ALARM_TIMER_LIMIT

BGJPAR

BGJPRC_UID / BGJPRC_SID

BGJ_LOG_JOBSTART

sid_BGJPAR

sid_USER

user_ACCOUNT / user_PASSWORD

COM_MPID

COM_BASE

ENABLE_RAC

JOBID

KNL_BASE

ORACLE_HOME

PGA_BASE

PGA_SIZE

SF_PBLKSIZE

SGA_BASE

SGA_ROUND

Oracle Net Services Variables

TNS_ADMIN

TNS_BEQ_TIMEOUT

TNS_UPDATE_IPNODE

Index