ORACLE File and File Variable Definition |
Virtual Machine |
 |
When defining an Oracle table in a PROIV File and File Variable Definition, the external file type ORA must be specified. PROIV fields should be defined with external data types as shown in the table below, for the appropriate Oracle data type to which they relate. When defining fields for Oracle data type NUMBER the external storage format must define the required numeric precision and scale in the format:
{S}b.a
where S indicates a signed value, b is the number of digits before the decimal point, and a is the number of digits after the decimal point.
For example, a storage format of S8.2 defines a precision of 10 (ten digits total) and a scale of 2 (two digits after the decimal point including sign). Note that the Oracle column definition for such a numeric format is in fact NUMBER(10,2).
|
Oracle Data Type |
PROIV Data Type |
PROIV Maximum Length |
PROIV External Datatype |
PROIV External Storage Format |
|
CHAR |
A, N or L(1) |
1-250 |
ALPHA |
{S}b.a |
|
VARCHAR2 |
A, N or L(1) |
1-250 |
ALPHA |
{S}b.a |
|
NUMBER |
A, N or L(1) |
1-20 |
NUMBER |
{S}b.a (2) |
|
REAL |
A, N or L(1) |
1-20 |
NUMBER |
{S}b.a (2) |
|
DOUBLE PRECISION |
A, N or L(1) |
1-20 |
NUMBER |
{S}b.a (2) |
|
DECIMAL |
A, N or L(1) |
1-20 |
NUMBER |
{S}b.a |
|
INTEGER (SMALLINT) |
A, N or L(1) |
1-20 |
NUMBER |
{S}b.a |
|
RAW |
A, N or L(1) |
1-250 |
ALPHA |
|
|
DATE (3) |
A |
8 |
DATE |
n/a |
|
DATE (3) |
A, N or L(1) |
5 |
DATE |
n/a |
Oracle Data Types and PROIV
(1) Type L is not allowed for Key variables.
(2) Only required when using PROIV Data Types N or L.
(3) Note that the format used within PROIV is always a PROIV internal date (number of days since 31st Dec 1799) for numerics and YYYYMMDD for alphas.
Topic ID: 720088