Home

	Expand Search

Installation and Reference Guide ClearConnect 1.3

Appendix A: ODBC SQL Commands and Datatype Conversion

Appendix A

This appendix describes the Version 2.0 ODBC calls and the datatype conversions that ClearConnect supports.

This chapter includes the following topics:

• Supported ODBC 2.0 SQL Commands
• Supported Datatype Conversion

Supported ODBC 2.0 SQL Commands

The following table shows the ODBC 2.0 SQL commands that ClearConnect. The SQL commands are ordered alphabetically by row.

Table A-1: Supported ODBC 2.0 SQL commands

SQLAllocConnect	SQLAllocEnv	SQLAllocStmt
SQLBindCol	SQLBindParameter	SQLCancel
SQLColAttributes	SQLColPrivileges	SQLColumns
SQLConnect	SQLDescribeCol	SQLDisconnect
SQLError	SQLExecDirect	SQLExecute
SQLExtendedFetch	SQLFetch	SQLForeignKeys
SQLFreeConnect	SQLFreeEnv	SQLFreeStmt
SQLGetConnectOption	SQLGetCursorName	SQLGetData
SQLGetEnvOption	SQLGetFunctions	SQLGetInfo
SQLGetStmtOption	SQLGetTypeInfo	SQLMoreResults
SQLNativeSQL	SQLNumResultCols	SQLPrepare
SQLPrimaryKeys	SQLRowCount	SQLSetConnectOption
SQLSetCursorName	SQLSetEnvOption	SQLSetParam
SQLSetStmtOption	SQLSpecialColumns	SQLStatistics
SQLTablePrivileges	SQLTables	SQLTransact

Supported Datatype Conversion

The tables in this section describe the ODBC datatype conversions that ClearConnect supports. Two considerations to keep in mind:

• Whenever CHAR or VARCHAR fields are converted to any numeric field, the CHAR/VARCHAR field must contain a valid numeric string; otherwise, the conversion is rejected with an error.
• When large datatypes convert to smaller datatypes (such as 4-byte integer to 2-byte smallint), ClearConnect rejects the conversion if the value is too large to fit into the smaller field.

  Table A-2: Datatype conversion supported by ClearConnect

  From This Datatype	To This Datatype
  CHAR	CHAR, VARCHAR, NUMERIC, DECIMAL, INTEGER, SMALLINT, DOUBLE, FLOAT, DATE, TIME, TIMESTAMP
  VARCHAR	CHAR, VARCHAR, NUMERIC, DECIMAL, INTEGER, SMALLINT, DOUBLE, FLOAT, DATE, TIME, TIMESTAMP
  NUMERIC	CHAR, VARCHAR, NUMERIC, DECIMAL, INTEGER, SMALLINT, DOUBLE, FLOAT
  DECIMAL	CHAR, VARCHAR, NUMERIC, DECIMAL, DOUBLE, FLOAT
  INTEGER	CHAR, VARCHAR, NUMERIC, DECIMAL, INTEGER, SMALLINT, DOUBLE, FLOAT
  SMALLINT	CHAR, VARCHAR, NUMERIC, DECIMAL, INTEGER, SMALLINT, DOUBLE, FLOAT
  DOUBLE	CHAR, VARCHAR, NUMERIC, DECIMAL, DOUBLE, FLOAT
  FLOAT	CHAR, VARCHAR, NUMERIC, DECIMAL, DOUBLE, FLOAT
  DATE	CHAR, VARCHAR, DATE, TIMESTAMP
  TIME	CHAR, VARCHAR, TIME, TIMESTAMP
  TIMESTAMP	CHAR, VARCHAR, DATE, TIME, TIMESTAMP
  BINARY	BINARY, VARBINARY, LONG VARBINARY, CHAR
  VARBINARY	BINARY, VARBINARY, LONG VARBINARY, VARCHAR
  LONG VARBINARY	BINARY, VARBINARY, LONG VARBINARY, VARCHAR
  LONG VARCHAR	CHAR, VARCHAR, LONG VARCHAR, VARBINARY
  TINYINT	CHAR, VARCHAR, NUMERIC, DECIMAL, INTEGER, SMALLINT, DOUBLE, FLOAT
  BIT	CHAR, VARCHAR, NUMERIC, DECIMAL, INTEGER, SMALLINT, DOUBLE, FLOAT

The following table summarizes the conversions between different datatypes that ClearConnect supports. A "Y" indicates that the conversion is supported; a blank indicates that the conversion is not supported.

Table A-3: Summary of datatype conversions

TO: FROM:

CHAR, VARCHAR

NUMERIC

DECIMAL

INTEGER

SMALLINT

TINYINT

FLOAT, DOUBLE

REAL

TIME

DATE

TIMESTAMP

BINARY, VARBINARY

LONG VARCHAR

LONG BINARY

CHAR

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

Y

VARCHAR

Y

Y

Y

Y

Y

Y

Y

Y

NUMERIC

Y

Y

Y

Y

Y

Y

Y

DECIMAL

Y

Y

Y

Y

Y

INTEGER

Y

Y

Y

Y

Y

Y

Y

SMALLINT

Y

Y

Y

Y

Y

Y

Y

TINYINT

Y

Y

Y

Y

Y

Y

Y

Y

FLOAT, DOUBLE

Y

Y

Y

Y

Y

REAL

Y

Y

Y

Y

Y

TIME

Y

Y

Y

DATE

Y

Y

Y

TIMESTAMP

Y

Y

BINARY, VARBINARY

Y

Y

Y

LONG VARCHAR

Y

Y

LONG VARBINARY

Y

Y