After exporting the results of a query to an output file, you may not be able to import the file back into the same definition of the accessed table. This is because the query may contain aggregates that will produce values beyond the boundaries of the original data types. In order to load the output file, you may need to create a new table with the appropriate data types for the values to be imported.
The following table shows the required data type conversions when using the binary format.
Data Type Conversions (Binary Format) | ||
---|---|---|
Operation |
Column Data Type |
Results Data Type |
SUM |
Smallint Int Bigint
|
BigInt |
SUM |
Float Double
|
Double |
SUM |
Numeric(N,M)
|
Decimal(18, M) |
AVG |
Smallint Int BigInt Double Numeric(N,M)
|
Double |
COUNT |
Smallint Int BigInt Double Numeric(N,M)
|
BigInt |
WebFOCUS |