MVSFORUMS.com

[vkarun1977]

Hi folks,
I develped the dynamic sql with wild cards in a cobol program but it does not fetch any rows.

I want to know ,Is it possible to develop a dynamic sql with wild card in a COBOL program. if so what steps i should take .


Let me knwo our ideas

example

select empno,empname from emp where name like 'jo%'

thanks

[Bithead]

If you are searching for JO% using a COBOL field greater than 4 bytes, DB2 will include any spaces in the field, so when you think you are searching for 'JO%', you are really seaching for 'JO% '. Either truncate the spaces using STRING ... DELIMITED BY SPACES or pad the field with % ('JO%%%%%%%').

[vkarun1977]

hi bithead...thanks for the reply..it worked to perfection. thanks a lot.