Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011

    Unanswered: Replace function for clob column

    Dear All,

    Replace function on Clob column in working on test environment instance and not working on production instances.Will there be any configuration settings to be modified at instance level.

    select replace(clobcolumn,'.orc','') from tablename -->is replacing string and throwing results in Test Environment
    select replace(clobcolumn,'.orc','') from tablename -->is returning all null values in Prod Environment

    Version :db2 9.7

    With Regards...
    Last edited by sayinirakesh; 11-28-11 at 04:49.

  2. #2
    Join Date
    Apr 2006
    Provided Answers: 11
    could you please indicate some details
    cmd executed - error messages - .......
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  3. #3
    Join Date
    Nov 2011
    select replace(clobcolumn,'.orc','') from tablename is executing fine and throwing results after replaing '.orc' string,but the same query in production environment is returning all null values.

    Version in both database :9.7

Posting Permissions

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