Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009

    Unanswered: CLOB Equivalent in DB2 9.1


    I was using the following command to show an encrypted value on a particular column on the DB2 7.1

    select CLOB(column name) from SCHEMA.TABLE_NAME where COL_NAME='value'

    Apparently the same CLOB is not working in DB2 9.1. Without the CLOB i can see only the encrypted value. Can anyone help me what is the equivalent of te CLOB to use in DB2 9.1 to get the value decrypted

    Thanks and Regards,

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    I'm not sure I understand how you use CLOB() for decryption of anything. What is the data type of the column in question, and how was it encrypted in the first place?
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jan 2007
    Jena, Germany
    CLOB has been working like this for years now (since DB2 V5 or even before). So you will have to be a bit more specific on what exactly you do, the schema you use, and the error you get.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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