No authorized routine of type "FUNCTION"

wishlister · #1 (**permalink**) 02-18-07, 06:11

DB2 ESE
what does this mean? what should i do?
No authorized routine named "||" of type "FUNCTION" having
compatible arguments was found.

guyprzytula · #2 (**permalink**) 02-18-07, 07:18

can you indicate the command executed and the complete message ?

wishlister · #3 (**permalink**) 02-18-07, 08:36

YEAR(B.BDAY)-YEAR(A.BDAY)||'OLDER THAN' //the error appears here
don't mind that my other statements maybe wrong

Marcus_A · #4 (**permalink**) 02-18-07, 09:26

I don't think you can concatenate numeric values. You must first cast them as char or varchar.

wishlister · #5 (**permalink**) 02-18-07, 10:41

oic.. i think i forgot that rule! tnx a lot!