SQL Server External Storage Formats |
Virtual Machine |
 |
When defining an RDBMS table in a PROIV file, the external file type SQLSERVER must be specified. PROIV fields should be defined with external data types as shown in the following table.
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: 560057