User`s guide
Using BS2000 Files for Input and Output
Getting Started 1-7
1.7 Using BS2000 Files for Input and Output
In most cases, Oracle Database for BS2000/OSD programs use the functions of the
C-BS2000 run-time system to access their input and output files. Oracle Database
programs can read and write
SAM
,
ISAM
, and
PAM
files.
1.7.1 Text Files
Textual data is usually stored in
SAM
or
ISAM
files; each record is taken to be one text
line. Examples are the SQL script files used by SQL*Plus and spool output files.
SQL*Loader input data is provided as
SAM
or
ISAM
files. These files may also contain
non-printable data, such as packed decimal or binary integer values. For
ISAM
files, the
key at the beginning of the record is generally ignored.
1.7.2 Binary Files
Binary data is usually stored in PAM files.
1.7.3 Generic Oracle Database File Name Syntax
The convention used in generic Oracle Database documentation represents file names
as two parts separated by a period, as in
LOGIN.SQL
. This syntax is correct for BS2000.
However, as there is no "current directory" concept in BS2000, you have to add a prefix
to the generic example names to get a full BS2000 file name.
1.7.4 Default File Name Extensions
Under BS2000/OSD, the Oracle Database utilities add default extensions to file names
only when the last component of the specified file name is longer than three
characters, or when only one component is specified, as shown in the following table.
This is similar to the file naming conventions used with Oracle Database on a UNIX
system.
1.7.5 Using Link Names
Instead of specifying a file name, in special cases, you can also refer to the link name of
a previously issued
BS2000 /SET-FILE-LINK
command by using the syntax
link=linkname
in places where a file name is requested. In this way, you can override
default file attributes, preallocate file space, and so on. There are a few exceptions
where the
link=linkname
notation cannot be used.
Original File Name Extended File Name
1.
TEST.TEST TEST.TEST.EXT
2.
TST TST.EXT
3.
T.T T.T
4.
TEST.TST TEST.TST