Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007

    Unanswered: How to view the CLOB data in DB2


    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.

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    Try creating a 16K and a 32K system temporary tablespace.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts