Skip Headers

Table of Contents Image Oracle8i Server User's Guide
Release 3 (8.1.7) for Fujitsu Siemens Computers BS2000/OSD

Part Number A95463-01
Go To Index
Index

Go to next page

Contents

Title and Copyright Information

Send Us Your Comments

Preface

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
Single-Task Mode
Connecting to the Oracle Server via Net8
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
interMedia 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 Instructions
Data Areas and Data Types
The Cursor Data Area
Binary Integers
Short Binary Integers
Optional Parameters
The Object Type Translator
Invoking Ott
Ott 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 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
Choosing Conversion Site

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_CONVERSION
NLS_LANG
OPS_JID
ORADUMP
ORASID
PRINTPAR
SQLPATH
SSSIDPWF
DBA Startup Variables
Address and Size Specification
BGJPAR
BGJPRC_UID / BGJPRC_SID
COM_MPID
COM_BASE
ENABLE_JAVA
JVM_BASE
JAVA_HOME
JOBID
KNL_BASE
PGA_BASE
PGA_SIZE
SF_PBLKSIZE
SGA_BASE
SGA_ROUND
Net8 Network Management Variables
TNS_ADMIN
TNS_BEQ_TIMEOUT
TNS_KEEP_SYSOUT
TNS_LOG_JOBSTART
TNS_MTT_TIMEOUT

Index


Go to next page
Oracle
Copyright © 2001 Oracle Corporation.

All Rights Reserved.
Go To Index
Index