Scalar function REPLACE

komal · New User Joined: 09 May 2005 Posts: 17

Hi All,
My COBOL+DB2 program is not getting compiled when i am trying to use SQL Scalar function REPLACE in my application program. Please find the sample SQL Query below

SELECT REPLACE(LTRIM(RTRIM(:xyz)),',','') into :xxx
FROM SYSIBM.SYSDUMMY1;

can any one let me know what is the issue

Thanks

Kiran

Craq Giegerich · Posted: Tue Mar 18, 2008 7:42 pm

What error message are you getting?

Phrzby Phil · Posted: Tue Mar 18, 2008 8:09 pm

Your functions are DB2. How about the argument you are applying the functions to - is it DB2 or COBOL?

Craq Giegerich · Posted: Tue Mar 18, 2008 8:10 pm

What are the definitions of xyz and xxx.

dbzTHEdinosauer · Posted: Tue Mar 18, 2008 9:43 pm

since xyz and xxx are host variables, it appears that the OP is using db2 cycles to accomplish abit of data manipulation instead of using the appropriate cobol commands.