Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

PowerExchange Datatype Conversions

PowerExchange Datatype Conversions

PowerExchange supports the conversions listed in the following tables.
An X in a cell in the table indicates that a conversion is supported. Not all systems support 64-bit integers. Where it is not supported, PowerExchange provides an emulation using floating point conversions. This provides precision up to approximately 15 digits, not the full 18 of a 64-bit integer.
The following table lists the supported conversions for the BIN, DATE, DBL, FLT, TIME, TIMESTAMP, and VARBIN datatypes:
From
To BIN
To CHAR
To DATE
To DBL
To FLT
To STRING
To TIME
To TIMESTAMP
To VARBIN
To VARCHAR
BIN
X
X
-
-
-
X
-
-
X
X
DATE
-
X
X
-
-
X
-
X
-
X
DBL
-
X
-
X
-
X
-
-
-
X
FLT
-
X
-
X
X
X
-
-
-
X
TIME
-
X
-
-
-
X
X
X
-
X
TIMESTAMP
-
X
X
-
-
X
X
X
-
X
VARBIN
X
X
-
-
-
X
-
-
X
X
The following table lists the supported conversions for the CHAR, NUMCHAR, NUM
xx
, PACKED, STRING, UPACKED, UZONED, VARCHAR, and ZONED datatypes:
From
To CHAR
To DBL
To NUMCHAR
To NUM
xx
To PACKED
UPACKED
To STRING
To VARCHAR
To ZONED
UZONED
CHAR
X
X
X
X
X
X
X
X
NUMCHAR
X
X
X
X
X
X
X
X
NUM
xx
X
X
X
X
X
X
X
X
PACKED
X
X
X
X
X
X
X
X
STRING
X
X
X
X
X
X
X
X
UPACKED
X
X
X
X
X
X
X
X
UZONED
X
X
X
X
X
X
X
X
VARCHAR
X
X
X
X
X
X
X
X
ZONED
X
X
X
X
X
X
X
X