Thread: UDF's & Stored Procedures

Hi Dave

Hard for me to anwser this cleanly. Would say that stored procedures should be ok (not by design) but could not anwser for the UDFs. In theory I would say they should work though.. So not clear why there was a problem. I will take a look into this when I get a chance. Please could you let me know which db system you are using ?

The addin is essentially a wrapper around the ADO library so if it works from ADO it should work from the addin. This said, the addin was setup for running SELECT Statements - and you cant use it for running active queries (queries that will modify the data). For this purpose, there some validation added it - to try to limit the SQL statements to SELECTS.. This validation was not done right (my mistake) so essentially you should be able to run SPs. And same for UDFs. But there must be something weird with the UDFS.. I will try to investigate this as soon as I can..

Sorry, I cant give a better anwser. If I had done things as was planned I could say that neither should work. But things got a bit off track so SPs should be fine. And UDFs should be too as far as I know.. But I never tested this..
have a good night
Al

Hi,

Thanks for the response...

I am running DB2 on an i5 (AS400), I did manage to get stored procedures to work, but the UDF syntax is converted to a string, so never gets past that.

I hope that helps,
Dave

Thanks alot Dave

Am trying to install DB2 Express-C tonight (the free one) and will try to replicate the issue. Will take me a few days to get a chance to set this up as busy with day job..

Thanks again for the feedback. If you have any criticisms or suggestions it would be very cool. I do quick testing on DB2 when there is a new release but very little so it is great to get feedback from people using DB2.

Have a nice night.
Al

Greetings!

I too am interested in working with the UDFs and stored procedures in our SQL server db.

I want to be able to do UPDATE as well.

Is this possible with SQLDrill?

Thanks.