32 K limit on record

udbdb2 · #1 (**permalink**) 11-19-04, 13:36

Is there any way to extend this limit for a table to store > 32K Records.
Or any work around.

Any thoughts 'd be greatly appreciated.

Marcus_A · #2 (**permalink**) 11-19-04, 18:54

You can store some of the data in a BLOB or CLOB column. These data types are not actually stored in the same place as the rest of the table, and they do not make use of bufferpools for cache, so performance is not quite as fast.

J Petruk · #3 (**permalink**) 11-20-04, 21:57

Quote:

Originally Posted by udbdb2

Is there any way to extend this limit for a table to store > 32K Records.
Or any work around.

Any thoughts 'd be greatly appreciated.

What specifically are you trying to store?

One workaround is to use two tables and access it via a view.

Internet Services

Web Development

Digital Marketing

Consumer Tech