Replace function for clob column

sayinirakesh · #1 (**permalink**) 11-28-11, 04:33

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...

przytula_guy · #2 (**permalink**) 11-28-11, 04:37

could you please indicate some details
cmd executed - error messages - .......

sayinirakesh · #3 (**permalink**) 11-28-11, 04:44

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

Internet Services

Web Development

Digital Marketing

Consumer Tech