How to compile / create the stored procedure in older version of DB2 ?

Question

I am having db2 9.5 whereas our client is having db2 9.1. So what happenes is, if i create a SP which is using any function present in 9.5 but not in 9.1 then the procedure will fail to compile / create on client side.

Is it possible to compile the SP as it will be in 9.1 ?

Answer 1

Interesting. I have migrated from 9.1 to 9.5 in our environment and I can't think of any big difference in terms of build-in functions. What function are you suspecting to e the troublemaker? What do you get as return?