I'm trying to run this query that I built with the query analyzer. For some reason it doesn't work. Can someone help me with this? Thanks

Chris

sun211d2r(fnsw)/fnsw/stress/indexora> less db2_q12.sql.net
SELECT DOCTABA.F_DOCNUMBER
FROM F_SW.DOCTABA AS DOCTABA
WHERE DOCTABA.A33 LIKE '3.0.0%'
ORDER BY DOCTABA.F_DOCNUMBER ASC;


sun211d2r(fnsw)/fnsw/stress/indexora> db2 -tvf chris.sql
SELECT DOCTABA.F_DOCNUMBER FROM F_SW.DOCTABA AS DOCTABA WHERE DOCTABA.A33 LIKE '3.0.0%' ORDER BY DOCTABA.F_DOCNUMBER ASC
SQL0440N No authorized routine named "LIKE" of type "FUNCTION" having
compatible arguments was found. SQLSTATE=42884

What is the data type for A33?

Actually I think you are using the table function (AS) incorrectly, even when it is not needed. Try this:

SELECT F_DOCNUMBER
FROM F_SW.DOCTABA
WHERE A33 LIKE '3.0.0%'
ORDER BY F_DOCNUMBER ASC;

A33 happens to be a VARCHAR datatype.

I vaguely remember something about the single quote being a problem if it's the last character in a line... Can you try rearranging your statement in the script file, something like:

SELECT DOCTABA.F_DOCNUMBER
FROM F_SW.DOCTABA AS DOCTABA
WHERE DOCTABA.A33 LIKE '3.0.0%' ORDER BY
DOCTABA.F_DOCNUMBER ASC;