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

ODBC and PowerExchange Datatype Equivalencies

ODBC and PowerExchange Datatype Equivalencies

The following table shows the ODBC and PowerExchange datatype equivalencies:
ODBC SQL Datatype
ODBC SQL C Datatype
PowerExchange Datatype
SQL_BINARY
-
DTLNET_BIN
SQL_BIT
SQL_C_BIT
DTLNET_BIT
SQL_CHAR
-
DTLNET_CHAR
SQL_DATE
SQL_C_DATE
DTLNET_DATE
SQL_DECIMAL
-
DTLNET_MONEY
SQL_DECIMAL
SQL_C_ULONG
DTLNET_NUM32U
SQL_DECIMAL
-
DTLNET_NUM64
SQL_DECIMAL
-
DTLNET_NUM64U
SQL_DECIMAL
-
DTLNET_NUMCHAR
SQL_DECIMAL
-
DTLNET_PACKED
SQL_DECIMAL
-
DTLNET_UPACKED
SQL_DECIMAL
-
DTLNET_UZONED
SQL_DECIMAL
-
DTLNET_ZONED
SQL_DOUBLE
SQL_C_DOUBLE
DTLNET_DOUBLE
SQL_INTEGER
SQL_C_USHORT
DTLNET_NUM16U
SQL_INTEGER
SQL_C_LONG and SQL_C_SLONG
DTLNET_NUM32
SQL_REAL
SQL_C_FLOAT
DTLNET_FLOAT
SQL_SMALLINT
SQL_C_SHORT and SQL_C_SSHORT
DTLNET_NUM16
SQL_SMALLINT
SQL_C_UTINYINT
DTLNET_NUM8U
SQL_TIME
SQL_C_TIME
DTLNET_TIME
SQL_TIMESTAMP
SQL_C_TIMESTAMP
DTLNET_TIMESTAMP
SQL_TINYINT
SQL_C_TINYINT and SQL_C_STINYINT
DTLNET_NUM8
SQL_VARBINARY
SQL_C_BINARY
DTLNET_VARBIN
SQL_VARCHAR
SQL_C_CHAR
DTLNET_STRING
SQL_VARCHAR
-
DTLNET_VARCHAR