ChewCheeLim

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.

Outcomes