What is the Varchar(Max) equivalent for DB2?

In DB2, is there a datatype that allows the string to grow and shrink dynamically l开发者_开发百科ike the Varchar(Max) datatype in SQL Server database?

No, according to this and this, DB2 doesn't have a large capacity text type.

You can use the VARCHAR(n) data type for text. Please keep in mind that n is the maximum length of bytes and not the character length. The maximum length is 32704 in byte. This is important if you are using a UTF-8 encoded database.

It should be "CLOB"

Guffa's link does mention this but fails to match CLOB and VARCHAR.