DSXchange

Sounds like Div() isn't valid for your database or the data types are wrong. Why not just use the normal "/" operator? thanks craig (chulett) for your response the data type is correct, but you may be right as I've tried to run the query in Toad and it seems Div() is not valid with our DB...

Hi all :) I am creating a server job and have encountered the below error message when debugging: [IBM][CLI Driver][DB2/NT] SQL0440N No authorized routine named "DIV" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884 Here is the piece of code for the SQL st...