SQLSERVER File and File Variable Definition |
Virtual Machine |
 |
When defining an SQLServer table in a PROIV File and File Variable Definition, the external file type SQLSERVE must be specified. PROIV fields should be defined with external data types for SQLServer are as follows:
When defining fields for 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 DB2 column definition for such a numeric format is in fact NUMBER(10,2).
|
Data Source Data Type |
PROIV Data Type |
PROIV Maximum Length |
PROIV External Type |
PROIV External Storage Type |
|
CHAR |
A, N, or L1 |
1-250 |
ALPHA |
{S}b,a |
|
VARCHAR2 |
A, N, or L1 |
1-250 |
ALPHA |
{S}b,a |
|
NUMBER |
A, N, or L1 |
1-20 |
NUMBER |
{S}b,a2 |
|
REAL |
A, N, or L1 |
1-20 |
NUMBER |
{S}b,a2 |
|
DOUBLE PRECISION |
A, N, or L1 |
1-20 |
NUMBER |
{S}b,a2 |
|
DECIMAL |
A, N, or L1 |
1-20 |
NUMBER |
{S}b,a |
|
INTEGER (SMALLINT) |
A, N, or L1 |
1-20 |
NUMBER |
{S}b,a |
|
RAW |
A, N, or L1 |
1-20 |
NUMBER |
{S}b,a |
|
DATE3 |
A, N, or L1 |
8 |
DATE |
n/a |
|
DATE3 |
A, N, or L1 |
5 |
DATE |
n/a |
Table 19. ODBC 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 31 Dec. 1999) for numeric and YYYYMMDD for alphas.
Topic ID: 720058