I need to convert some SQL server sql to db2. The sql I am starting
with looks like this:

WHERE (UserSecurityAttributes.dAttributeName LIKE '%' +
DocumentAccounts.dDocAccount + '%')

They are trying to allow padding of extra characters on either side of
the column name. DB2 returns the error below when a like is used with a
column name.

SQL0132N A LIKE predicate or POSSTR scalar function is not valid
because the
first operand is not a string expression or the second operand is not a
string. SQLSTATE=42824

Is there another way to do this in db2?

Thanks,

Keith

DB2 & UDB email list listserv db2-l LazyDBA home page