Hello

How can i view CLOB data in DB2. When I used CAST(COL1 AS VARCHAR(3200)) or VARCHAR(COL1). {COL1 is CLOB DataType} I get error saying

ERROR [54048] [IBM][DB2/NT] SQL1585N A system temporary table space with sufficient page size does not exist. SQLSTATE=54048

I created two temporary tablespaces using 8K page size. But still I get the same issue.

Thanks in Anticipation.

Try creating a 16K and a 32K system temporary tablespace.

Andy