Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Using Oracle Database Documentation
• Related Documents
• Conventions Used in this Manual

1 Getting Started

• 1.1 The Oracle Database Environment-Definition File
  • 1.1.1 Generating the Environment-Definition File
  • 1.1.2 Calling the Environment-Definition File
  • 1.1.3 Specifying the Environment Variables
• 1.2 The ORALOAD Library
• 1.3 Starting Oracle Utilities with BS2000 SDF commands
• 1.4 Starting Oracle Utilities in UNIX-Style
• 1.5 Starting Oracle Utilities in the POSIX environment
• 1.6 Connecting to an Oracle Instance
  • 1.6.1 Default Connections
  • 1.6.2 Accessing an Oracle Instance
• 1.7 Using BS2000 Files for Input and Output
  • 1.7.1 Text Files
  • 1.7.2 Binary Files
  • 1.7.3 Generic Oracle Database File Name Syntax
  • 1.7.4 Default File Name Extensions
  • 1.7.5 Using Link Names
  • 1.7.6 Fixed Link Names

2 Oracle Database Utilities

• 2.1 SQL*Loader
  • 2.1.1 Starting the SQL*Loader Utility
  • 2.1.2 Using the SQL*Loader Demonstration Files
• 2.2 The Export Utility
  • 2.2.1 Starting the Export Utility
  • 2.2.2 Exporting to Foreign Systems
    • 2.2.2.1 Transferring Data by Tape
    • 2.2.2.2 Transferring Data by File Transfer
• 2.3 The Import Utility
  • 2.3.1 Starting the Import Utility
  • 2.3.2 Importing from Foreign Systems
    • 2.3.2.1 Import File Block Size
    • 2.3.2.2 Transferring Data by Tape
    • 2.3.2.3 Transferring Data by File Transfer
• 2.4 The Data Pump Export Utility
  • 2.4.1 Starting the Data Pump Export Utility
• 2.5 The Data Pump Import Utility
  • 2.5.1 Starting the Data Pump Import Utility
• 2.6 Oracle Text Loader

3 SQL*Plus

• 3.1 Running SQL*Plus
  • 3.1.1 SQL*Plus User Profiles
    • 3.1.1.1 The GLOGIN.SQL Global Startup File
    • 3.1.1.2 The LOGIN.SQL User Startup File
  • 3.1.2 Starting SQL*Plus
  • 3.1.3 Interrupting SQL*Plus
  • 3.1.4 Issuing BS2000 Commands from SQL*Plus
  • 3.1.5 Starting the BS2000 Editor
  • 3.1.6 The SQL ASCII Function
  • 3.1.7 Spooling SQL*Plus Output
  • 3.1.8 Using SQL*Plus Symbols
• 3.2 Specifying the Search Path for SQL*Plus Command Files
• 3.3 Sample Schemas and SQL*Plus
• 3.4 SQL*Plus Limits
• 3.5 Using SQL*Plus in the POSIX environment
  • 3.5.1 Starting SQL*Plus
  • 3.5.2 Running Shell Commands From SQL*Plus
  • 3.5.3 Using an Editor in SQL*plus

4 PL/SQL

• 4.1 PL/SQL Demonstrations
  • 4.1.1 PL/SQL Demos for the Kernel
  • 4.1.2 PL/SQL Demos for Precompilers

5 Programmatic Interfaces

• 5.1 Overview
  • 5.1.1 Architecture of the Programmatic Interfaces
  • 5.1.2 PL/SQL
• 5.2 Building and Running a Programmatic Interface Application
  • 5.2.1 Existing Applications
  • 5.2.2 Precompilers
    • 5.2.2.1 Include Files
    • 5.2.2.2 User-Specific Configuration Files
    • 5.2.2.3 Input, Output, and List-files
  • 5.2.3 Additional Remarks
• 5.3 Pro*C/C++
  • 5.3.1 Starting Pro*C
  • 5.3.2 Pro*C Include, System Configuration and Demo Files
  • 5.3.3 SQLLIB Calls
  • 5.3.4 Linking Pro*C
  • 5.3.5 The Pro*C SQLCPR.H Header File
  • 5.3.6 UTM Applications
• 5.4 Pro*COBOL
  • 5.4.1 Starting Pro*COBOL
  • 5.4.2 Pro*COBOL Include, System Configuration, and Demo Files
  • 5.4.3 SQLLIB Calls
  • 5.4.4 Linking Pro*COBOL
  • 5.4.5 openUTM Applications
• 5.5 The Oracle Call Interface
  • 5.5.1 Linking OCI
  • 5.5.2 Optional Parameters
• 5.6 The Object Type Translator
  • 5.6.1 Starting Ott
  • 5.6.2 Ott System Configuration File

6 Using the Oracle Database Under openUTM

• 6.1 SQL Operations
  • 6.1.1 CONNECT
  • 6.1.2 COMMIT
  • 6.1.3 ROLLBACK
  • 6.1.4 SAVEPOINT
  • 6.1.5 Cursor Operations
  • 6.1.6 Dynamic SQL
  • 6.1.7 PL/SQL
  • 6.1.8 Autocommit
• 6.2 UTM Operations
  • 6.2.1 RSET and PEND RS
  • 6.2.2 PEND ER and PEND FR
  • 6.2.3 PEND KP, PEND PR, and PEND PA
  • 6.2.4 PEND RE, PEND FI, PEND SP, and PEND FC

7 Globalization Support

• 7.1 Specifying a Language, Territory, and Character Set
  • 7.1.1 Oracle Database
  • 7.1.2 Other Oracle Database Products
• 7.2 Supported Language Conventions
• 7.3 Supported Territories
• 7.4 Supported Character Sets
• 7.5 Location of Message Files
• 7.6 Linguistic Definitions

A Oracle Error Messages for BS2000/OSD

B Oracle Environment Variables

• B.1 ORAENV Rules
• B.2 Built-in Variables
  • B.2.1 LOGNAME
  • B.2.2 ORAUID
  • B.2.3 PGM
  • B.2.4 TERM
  • B.2.5 TSN
• B.3 General Variables
  • B.3.1 CLN_BASE
  • B.3.2 CLN_MPID
  • B.3.3 DEFAULT_CONNECTION
  • B.3.4 EXP_CLIB_FILE_IO
  • B.3.5 IMP_CLIB_FILE_IO
  • B.3.6 NLS_LANG
  • B.3.7 OPS_JID
  • B.3.8 ORADUMP
  • B.3.9 ORASID
  • B.3.10 PRINTPAR
  • B.3.11 SQLPATH
  • B.3.12 SSSIDPWF
• B.4 DBA Startup Variables
  • B.4.1 Address and Size Specification
  • B.4.2 BGJPAR
  • B.4.3 BGJPRC_UID / BGJPRC_SID
  • B.4.4 BGJ_LOG_JOBSTART
  • B.4.5 sid_BGJPAR
  • B.4.6 sid_USER
  • B.4.7 user_ACCOUNT/ user_PASSWORD
  • B.4.8 COM_MPID
  • B.4.9 COM_BASE
  • B.4.10 JOBID
  • B.4.11 KNL_BASE
  • B.4.12 ORACLE_HOME
  • B.4.13 PGA_BASE
  • B.4.14 PGA_SIZE
  • B.4.15 SF_PBLKSIZE
  • B.4.16 SGA_BASE
• B.5 Oracle Net Services Variables
  • B.5.1 BREAK_HANDLING
  • B.5.2 TNS_ADMIN
  • B.5.3 TNS_BEQ_TIMEOUT
  • B.5.4 TNS_UPDATE_IPNODE

Index