In DB2, is there a datatype that allows the string to grow and shrink dynamically like Varchar(Max) in SQL Server?
A:
No, according to this and this, DB2 doesn't have a large capacity text type.
You can use the Varchar data type for text up to 32767 characters.
Guffa
2010-06-01 12:39:33
It's CLOB but your link fails to match this with varchar... http://wiki.gxtechnical.com/commwiki/servlet/hwiki?Data+types+of+attributes+in+the+DBMS,
gbn
2010-06-01 13:03:55
A:
It should be "CLOB"
Guffa's link does mention this but fails to match CLOB and VARCHAR.
gbn
2010-06-01 13:01:42
I understood the question a little bit different and would answer it with yes. The datatype is called `varchar` (according to both links from Guffa. Zian just needs to define how big he needs max to be. It might differ than. May be he needs `long varchar`.
Peter Schuetze
2010-06-02 20:20:50