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 and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: 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

0 COMMENTS

We’d like to hear from you!