1.4.1 DSNTIAUL
On mainframe, DSNTIAUL program is used to unload
data from DB2 tables into sequential data sets. The data is copied
to the data sets and is not deleted from the table.
To unload data from Oracle Database tables, Batch runtime
provides you DSNTIAUL utility, which has the same
functionality as DSNTIAUL program on mainframe with
DB2.
The following table shows the supported DB2 data types and their conversion to the Oracle Database target.
Table 1-9 Supported Data Types
| Data Type in DB2 on Mainframe | Mapped Data Type in Oracle Database |
|---|---|
DECIMAL(p)
|
NUMBER(p)
|
DECIMAL(p,s)
|
NUMBER(p,s)
|
CHAR(n)
|
CHAR(n)
|
VARCHAR(n)
|
VARCHAR2(n)
|
TIMESTAMP
Note: Only supports the default format "YYYY-MM-DD-HH24.MI.SS.FF6".
|
TIMESTAMP
|
TIME
Note: Only supports the default format "HH24.MI.SS".
|
DATE
|
DATE
Note: Only supports the default format "YYYY-MM-DD".
|
DATE
|
real
|
BINARY_DOUBLE
|
Float(n) (1<=n<=21)
|
BINARY_DOUBLE
|
Float(n) (22<=n<=53)
|
BINARY_DOUBLE
|
Double
|
BINARY_DOUBLE
|
Parent topic: DB2 Utilities