Index

A B C D E F G H I J L M N O P R S T U V W X Z

Symbols

_CEE_ENVFILE mechanism, LE, 2.2.4.2

A

Access Manager for CICS TS

accessing multiple Oracle databases, 6.6.1.5

accessing Oracle and DB2 databases, 6.6.1.6

application design considerations, 6.6.1

configured with EDF option, 6.6.2

CONNECT statements, 6.6.1.2

considerations for building applications, 6.6.4

cursor considerations, 6.6.1.4

developing applications, 6.6

environment variables, 6.6.3

overview, 1.4.1

running programs, 6.6.5

SQL statement restrictions, 6.6.1.7

synchronization of Oracle updates, 6.6.1.3

versions supported, 6.6.1.1

Access Manager for IMS TM

accessing multiple Oracle databases, 6.7.1.5

accessing Oracle and DB2 databases, 6.7.1.7

application design considerations, 6.7.1

CONNECT not supported, 6.7.1.2

considerations for building applications, 6.7.3

cursor considerations, 6.7.1.4

developing applications, 6.7

environment variables, 6.7.2

overview, 1.4.1

processing Oracle errors, 6.7.1.8

SQL statement restrictions, 6.7.1.6

synchronization of Oracle updates, 6.7.1.3

versions supported, 6.7.1.1

API programs, Oracle

building, 6.4

precompile/compile wth name mapping, 6.4.2

prelink and link method, 6.4.1

API stub

alternate (ORASTBS), 6.4

description, 2.2.2.3

load modules using alternate, 6.4

applications

building, 6.3

CICS TS, 6.6

compiler options, 6.3.2

compiling programs, 6.3.3

design considerations, 6.2

dynamic linkage techniques, 6.2.2.2

error handling, 6.5.1

IMS TM, 6.7

interface initialization, 6.5.1

linking programs, 6.3.4

migrating, 7

multiple LE enclaves, 6.2.2.3

multitasking, 6.2.2.4

OCI interface to publish/subscribe, 6.2.2.7

Oracle Precompiler options, 6.3.1.3

overview, 1.4

POSIX threading, 6.2.2.6

precompiling programs, 6.3.1

processing, 6.5.1

requirements for basic, 6.2.1

requirements for complex, 6.2.2

resources and cleanup, 6.5.2

runtime access requirements, 2.2.2

runtime considerations, 6.5

sample JCL to build Oracle Precompiler program, 6.3.5.1

software and hardware states, 6.2.2.5

using Oracl-supplied procedures, 6.3.5

z/OS Assembler language, 6.2.2.1

ATTACH macro, z/OS, 6.2.2.2.7

Attention interrupts, TSO, 2.2.2.3

B

bad and discard files

attributres, 4.2.3

SQL*Loader, 4.2.2.4, 4.2.4

batch

environment, 2.2

environment variables, 2.2.4.2

linking programs, 6.3.4.1

parameters, 2.2.3.1

redirection operators, 2.3.3.2

running Oracle Precompilers, 6.3.1.7

C

CALL macro, z/OS, 6.2.2.2.6

C/C++ compiler

options, 6.3.2.1

overview, 2.1

character data

Oracle Database for z/OS, 5.1

partitioned tables, 5.1.2

SQL queries, 5.1.1

SQL statements, 5.1.3

CMDLOAD data set

description, 2.2.2.1

COBOL compiler

options, 6.3.2.2

COBOL DYNAM option

exceptions for COBOL applications, 6.5.1

linking programs using, 6.3.4.2

OCI functions with callbacks, 6.3.3

ORASTBX, 2.2.2.3

Pro*COBOL DLL option, 6.3.3

Pro*COBOL precompiler support, 6.3.1.6.2

compilers, IBM

options, 6.3.2

compiling programs

OCCI programs to Run in Batch and TSO Environments, 6.3.3.2

overview, 6.3.3

sample commands for shell, 6.3.3.1

cross-memory services, z/OS, 1.3

D

data files

bad and discard attributes, 4.2.3

VSAM, 4.2.3

data sets

DCB attributes, 2.3.5

name filespecs, 2.3.4.2

name prefixing, 2.5.4

names, 2.3.2.1

SYSOUT, 2.3.2.3

Datapump Export and Import

file processing on server, 5.2.7

interactive mode, 4.4.4

invocation, 4.4.1

log files, 4.4.2

overview, 4.4

processing, 4.4.2, 4.4.3

return codes, 4.4.5

DCB attributes

data set, 2.3.5

default, 2.3.5, 2.3.5.1

FNA, 2.3.5.2

without FNA, 2.3.5.3

DD names

description, 2.3.2.2

directory object, Oracle Database for z/OS, 5.2.2

dynamic linkage techniques, 6.2.2.2

E

enclaves

multiple, 6.2.2.3

Enterprise Manager, 1.5

ENVARn runtime option, 2.2.4.2

environment variables

Access Manager for CICS TS, 6.6.3, 6.7.2

batch and TSO, 2.2.4.2

description, 2.2.4.3

ORA$ENV file, 2.2.4.4

overview, 2.2.4

used by Oracle Database for z/OS, A

z/OS UNIX shell, 2.2.4.1

execution environments, z/OS, 2.2

Export and Import utilities

cross-system capabilities, 4.3.3

examples, 4.3.6

export file, 4.3.2

invocation, 4.3.1

overview, 4.3

return codes, 4.3.4

unsupported features, 4.3.5

extension processing of file specs, 2.3.4.4

external LOB files (BFILES), 5.2.5

external tables, 5.2.6

F

FATTR string, 2.3.4.7

fetch() function, C library, 6.2.2.2.5

file attribute compatibility

Oracle C, 2.5.3

file names

description, 2.3

file processing

Oracle Database for z/OS, 5.2

files

description of Oracle database, 2.3

processing, 2.3

redirection, 2.3.3

SQL, 4.1.4

standard, 2.3.3

syntax, 2.3.2

filespecs

data set name parts, 2.3.4.2

description, 2.3.1

extension procession, 2.3.4.4

HFS file name parts, 2.3.4.3

manipulation, 2.3.4

Oracle C runtime compatibility, 2.5

runtime compatibility, 2.5.2

syntax, 2.3.2

FNA (File Name Augmentation)

attribute assignment, 2.3.4.7

description, 2.3.4.5

FATTR attrs string, 2.3.4.7

keywords and descriptions, 2.3.4.7

syntax transformation (FNAME), 2.3.4.6

FNAME syntax transformation, 2.3.4.6

G

Gateways, Oracle Transparent, 1.1

H

HFS

file name parts, 2.3.4.3

HFS (Hierarchical File System)

shell environment, 2.2

HFS files

syntax, 2.3.2.5

I

INTEGER values

Pro*COBOL precompiler, 6.3.1.6.2

interrupt processing

TSO and z/OS UNIX shell, 2.4

J

Java, Oracle Database, 5.2.4

L

Language Environment (LE), IBM

multiple enclaves, 6.2.2.3

overview, 1.1

runtime, 2.2.2.2

ldap.ora file

description, 3.2.3

LIBCLNTS program

description, 2.2.2.3

initialization, 6.5.1

LINK macro, z/OS, 6.2.2.2.6

linking programs

batch and TSO, 6.3.4.1

COBOL using DYNAM, 6.3.4.2

overview, 6.3.4

to run in a shell, 6.3.4.5

linklist library

description, 2.2.2.1

listener, Oracle Net, 1.3

LOAD macro, z/OS, 6.2.2.2.6

load modules

building traditional, 6.4

LOG_DIRECTORY_CLIENT parameter, 3.2.1.1

LOG_FILE_CLIENT parameter, 3.2.1.2

LPA library

description, 2.2.2.1

M

Make

building OCI programs, 6.3.5.8

building precompiler programs, 6.3.5.2

MESG data set

description, 2.2.2.4

migrating applications

from Oracle8i, 7.2

from Oracle9i, 7.3

overview, 7.1

multitasking applications, 6.2.2.4

N

networking

Oracle Net, 1.3

overview, 1.3

NLS (National Language Support)

description, 2.2.2.4

O

ONAME parameter

Pro*PL/I precompiler, 6.3.1.6.5

ORA$ENV DD statement, 2.2.4.2

ORA$ENV environment variable file, 2.2.4.3

ORA$LIB DD statement, 2.2.2.4

Oracle C runtime

compatibility, 2.5.1

data set name prefixing, 2.5.4

file attribute compatibility, 2.5.3

filespec compatibility, 2.5.2

runtime compatibility, 2.5

standard files and redirection compatibility, 2.5.5

Oracle Call Interface (OCCI)

sample JCL to build a program, 6.3.5.7

Oracle Call Interface (OCI)

ENUMSIZE(INT), 6.3.1.6.3

interface to publish/subscribe, 6.2.2.7

OTT utility, 6.3.1.6.3

overview, 1.4.2

sample JCL to build a program, 6.3.5.6

sample programs, 6.3.5.9

using Make to build programs, 6.3.5.8

Oracle Database for z/OS

character data, 5.1

directory object, 5.2.2

environment variables, A

file processing, 5.2

migrating applications, 7

security considerations, 5.2.1

SQL queries, 5.1.1

Oracle home

description, 2.2.2.1

Oracle Net

description, 1.3

files, 3.2

ldap.ora, 3.2.3

listener, 1.3

output files, 3.2.3

overview, 3

protocol and address determination, 3.1.1

protocols, 3.1

sqlnet.ora, 3.2.1

TCP protocol, 3.1.3

TCP/IP protocol, 1.3

tnsnames.ora, 3.2.2

XM protocol address, 3.1.2.1

XM protocol description, 3.1.2

z/OS cross-memory services, 1.3

Oracle Transparent Gateways, 1.1

ORASTAX runtime module

TSO environments, 2.2.2.3

ORASTBX module, 2.2.2.3

OSDI (Operating System Dependent Interface) subsystem, 1.1

P

PA1key interrupts, TSO, 2.2.2.3

parameters

batch (JCL), 2.2.3.1

containing spaces, 2.2.3.4

tool and utility conventions, 2.2.3

TSO, 2.2.3.2

where specified, 2.2.3

z/OS UNIX shell, 2.2.3.3

PATH environment variable

description, 2.2.2.1

PL/I compiler

options, 6.3.2.3

POSIX

environment, 2.2.1

threading applications, 6.2.2.6

Precompilers, Oracle

batch and TSO considerations, 6.3.1.7

commands for running in a shell, 6.3.1.12

configuration files, 6.3.1.4

executables, 6.3.1.1

INCLUDE files, Oracle Precompiler, 6.3.1.2

language-specific coding considerations, 6.3.1.6

options, 6.3.1.3

return codes, 6.3.1.5

sample JCL for Pro*C in batch, 6.3.1.8

sample JCL for Pro*COBOL in batch, 6.3.1.9

sample JCL for Pro*FORTRAN in batch, 6.3.1.10

sample JCL for Pro*PL/I in batch, 6.3.1.11

sample JCL to build programs, 6.3.5.1

using Make to build programs, 6.3.5.2

precompiling programs, 6.3.1

prefixing of data set names, 2.5.4

Pro*C precompiler

ENUMSIZE(INT), 6.3.1.6.3

OTT utility, 6.3.1.6.3

sample programs, 6.3.5.5

Pro*COBOL precompiler

DYNAM option, 6.3.1.6.2

RETURN-CODEspecial register, 6.3.1.6.2

sample programs, 6.3.5.3

Pro*FORTRAN precompiler

sample programs, 6.3.5.4

Pro*PL/I precompiler

ONAME parameter, 6.3.1.6.5

procedures, Oracle-supplied, 6.3.5

program

runtime access requirements, 2.2.2

program interface code, Oracle (LIBCLNTS), 2.2.2.3

putenv() statement, 2.2.4.2

R

Recovery Manager, 1.5

redirection of standard files, 2.3.3

redirection operators, TSO and batch, 2.3.3.2

return codes

Datapump Export and Import, 4.4.5

Export and Import Utilities, 4.3.4

Oracle Precompilers, 6.3.1.5

SQL*Loader, 4.2.5

SQL*Plus, 4.1.9

TKPROF utility, 4.5.4

RETURN-CODEspecial register

Pro*COBOL precompiler, 6.3.1.6.2

runtime compatibility

controlling, 2.5.1

runtime considerations

applications, 6.5

runtime program

access requirements, 2.2.2

S

security considerations

Oracle Database for z/OS, 5.2.1

shell environments

sample commands for compiling and linking programs, 6.3.4.4

z/OS UNIX, 2.2

SQL queries, Oracle Database for z/OS, 5.1.1

SQL statements

character data, 5.1.3

SQL*Loader

bad and discard files, 4.2.2.4, 4.2.2.4, 4.2.4

control file, 4.2.2.1

data files, 4.2.2.3

examples, 4.2.6

files and filespecs, 4.2.2

invocation, 4.2.1

log file, 4.2.2.2

overview, 4.2

return codes, 4.2.5

SQL*Plus

EDIT command, 4.1.5

examples, 4.1.11

files, 4.1.4

HOST command, 4.1.7

invocation, 4.1.1

output interruption, 4.1.2

overview, 4.1

profile names, 4.1.3

return codes, 4.1.9

SPOOL command, 4.1.6

timing processing, 4.1.8

unsupported features, 4.1.10

sqlnet.ora file

description, 3.2.1

standard files, 2.3.3

SYSOUT data sets, 2.3.2.3

system() function, C library, 6.2.2.2.4

T

TCP protocol, 3.1.3

TCP/IP protocol, 1.3

TKPROF utility

example, 4.5.5

input trace file, 4.5.2

invocation, 4.5.1

output files, 4.5.3

overview, 4.5

return codes, 4.5.4

tnsnames.ora file

description, 3.2.2

tools

overview, 1.2

TRACE_DIRECTORY_CLIENT parameter, 3.2.1.3

TRACE_FILE_CLIENT parameter, 3.2.1.4

TSO

CALL command, 2.2.3.2

environment, 2.2

environment variables, 2.2.4.2

filespec, 2.3.2.4

interrupt processing, 2.4

linking programs, 6.3.4.1

parameters, 2.2.3.2

redirection operators, 2.3.3.2

running Oracle Precompilers, 6.3.1.7

U

UNIX System Services, z/OS

environment, 2.2

environment variables, 2.2.4.1

interrupt processing, 2.4

parameters, 2.2.3.3

utilities

overview, 1.2

UTL_FILE PL/SQL package, 5.2.3

V

VSAM data files, 4.2.3

W

Workload Manager (WLM)

overview, 1.1

X

XM protocol

examples, 3.1.2.2

Oracle Net, 3.1.2

Z

z/OS Assembler language

applications, 6.2.2.1