Exporting and Importing Query Results

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