Create 'stored procedure' or user defined 'function' in PI SQL Commander?

Discussion created by ChewCheeLim on Feb 5, 2014
Latest reply on Feb 13, 2014 by ChewCheeLim
Hi there, Can I create a stored procedure or user-defined-function in PI SQL Commander? (or under the hood, should say PI or AF) I want to execute multiple SQL statements ( a mini program in SQL), reading through PI OLEDB Enterprise User Guide, I didn't see anything about this 2 topics. I want to confirm my findings. The only option that I have is to issue multiple SQL statements from C# program to get my result set, instead of 1 single call against 'stored procedure'? On the other hand, I saw a blog about using CLR. This does require a linked server to be set up correct? If there is a sample code\app or tutorial? Thanks a lot.