782
[OCI] Tag
Connect to Oracle Server
Format
OPEN (chan[fileopt1])"[OCI]sid[;table][;fileopt2]"
Where:
[OCI]
File tag clause to inform ProvideX that it will be opening an Oracle
database.
chan
Channel or logical file number to open.
fileopt1
File options. Supported options include:
BSZ=num Buffer size (in bytes)
ERR=stmtref Error transfer
IOL=iolref Default IOList
NBF=num Dedicated number of buffers
REC=string$ Record prefix (REC=VIS(string$) can also be used).
fileopt2
sid
Oracle System ID of file to open. If not supplied, then the value of the
environment variable ORACLE_SID is used. String expression.
table
Name of the table to open. If the table name is not supplied, then SQL
statements sent to the database must be created by the application and sent
via one of the following commands:
WRITE (chan) SQL$
WRITE RECORD (chan) SQL$
READ (chan, KEY="!", SQL$)
Description
The [OCI] tag is used as a prefix in an OPEN statement to denote that ProvideX is to
route all file I/O requests to an external (not ProvideX) Oracle database. (OCI is an
acronym for Oracle Call Interface.) Once you open a channel for [OCI] use, you can
use it just like any other channel (i.e., for file I/O). It remains open until you close it.
Note: This feature requires activation of ProvideX OCI support (available for
Windows, Redhat, HP UX, Sun Solaris, and AIX). Refer to the ProvideX website for
licensing information. Use TCB(200) to check if OCI is supported on the platform.
[OCI] OPT= Parameters
The OPEN options for connecting to an Oracle server are listed below: '"
"AUTO_INDEX=" Used to include hints and index numbers to SELECT statements
"DATEFMT="
Date format mask applying to all date fields in table. (INI supported) This
can be a combination of Y M D with any other characters; e.g., to convert
dates to 4-character year, month and day: DATEFMT=YYYYMMDD.Other
characters are inserted as is; e.g., DATEFMT=YY/MM/DD with a date of
March 1, 2004 would be returned as 04/03/01.