Product Documentation

ODBC - c-tree Plus Edition

Previous Topic

Next Topic

Driver Constraints

The following limits apply to the c-tree ODBC Driver. Addition limits may be imposed by third-party ODBC applications.

Description

Value

Concurrently open tables:

16-bit multi-user non-server driver

All others

 

305

405

Number of rows:

2 billion

Number of columns in a query:

256

Size of a column:

2 gigabytes

Number of connections:

limited by memory

Table, index and column name length:

64 characters

Table qualifier:

68 characters

Maximum characters in a literal:

1000

Maximum columns in a CREATE TABLE statement:

256

Maximum ANDed predicates:

This example uses three ANDed predicates:

SELECT * FROM abc

WHERE c1 AND c2 AND c3 AND c4

300

Number of joined tables:

limited by memory

Previous Topic

Next Topic

Limitations of SQL_LONGVARCHAR

  1. The LIKE predicate operates on the first 65500 characters of the column data.
  2. All other predicates operate on the first 256 characters of the column data.
  3. SELECT statements with GROUP BY, DISTINCT and ORDER BY return all of the data but only order on the first 256 characters of the column data.

TOCIndex