The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
Hi Danny,Please see attached document.RegardsMo
Hi Danny,Please see attached document.RegardsMo ------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840-------------------------------------------------------------------------Original Message:Sent: 06-01-2019 05:32 PMFrom: Danny ValenzuelaSubject: Execute a SQL Store Procedure in ScriptHi,I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.I am using Monarch Automator 15.3. I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.Any help is much appreciated.Thanks,------------------------------Danny ValenzuelaSenior Database Administrator------------------------------"
Hi Mo,This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.Thank you,Leonid------------------------------Leonid ShteyngardtApp Dev ManagerCanaccord Genuity Inc.New York NY(212) 389-8176-------------------------------------------------------------------------Original Message:Sent: 06-02-2019 09:23 PMFrom: Mahmoud AbdolrahimSubject: Execute a SQL Store Procedure in ScriptHi Danny,Please see attached document.RegardsMo ------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840------------------------------Original Message:Sent: 06-01-2019 05:32 PMFrom: Danny ValenzuelaSubject: Execute a SQL Store Procedure in ScriptHi,I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.I am using Monarch Automator 15.3. I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.Any help is much appreciated.Thanks,------------------------------Danny ValenzuelaSenior Database Administrator------------------------------"
Hi Mo,This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.Thank you,Leonid------------------------------Leonid ShteyngardtApp Dev ManagerCanaccord Genuity Inc.New York NY(212) 389-8176-------------------------------------------------------------------------Original Message:Sent: 06-02-2019 09:23 PMFrom: Mahmoud AbdolrahimSubject: Execute a SQL Store Procedure in Script
Hi Leonid,Attached document provides an example of executing a TSQL function. In this example I used one of the Monarch Server Automator User Defined functions, which returns the current Automator version number, and assign it to a global variable.RegardsMo------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840-------------------------------------------------------------------------Original Message:Sent: 06-06-2019 07:34 AMFrom: Leonid ShteyngardtSubject: Execute a SQL Store Procedure in ScriptHi Mo,This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.Thank you,Leonid------------------------------Leonid ShteyngardtApp Dev ManagerCanaccord Genuity Inc.New York NY(212) 389-8176------------------------------Original Message:Sent: 06-02-2019 09:23 PMFrom: Mahmoud AbdolrahimSubject: Execute a SQL Store Procedure in ScriptHi Danny,Please see attached document.RegardsMo ------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840Original Message:Sent: 06-01-2019 05:32 PMFrom: Danny ValenzuelaSubject: Execute a SQL Store Procedure in ScriptHi,I am having such a hard time trying to figure out how to connect to a SQL Server and execute a stored procedure.I am using Monarch Automator 15.3. I added a Script to the Visual process but there isn't any good tutorials that I can find to do this.Any help is much appreciated.Thanks,------------------------------Danny ValenzuelaSenior Database Administrator------------------------------"
Hi Leonid,Attached document provides an example of executing a TSQL function. In this example I used one of the Monarch Server Automator User Defined functions, which returns the current Automator version number, and assign it to a global variable.RegardsMo------------------------------Mahmoud AbdolrahimSenior Implementation & Integration EngineerDatawatch CorporationMA(978) 935-3840-------------------------------------------------------------------------Original Message:Sent: 06-06-2019 07:34 AMFrom: Leonid ShteyngardtSubject: Execute a SQL Store Procedure in ScriptHi Mo,This is a very useful script that we were looking for. I have one question - instead of calling a stored procedure that has no output, can we call a SQL function (or direct Select from the table) that will return exactly one value - "select dbo.f_getBusinessDate()" and stored it in the Automator global variable. Then we can use this variable throughout all processes that need to insert data into different tables using business date, rather then calendar date.Thank you,Leonid------------------------------Leonid ShteyngardtApp Dev ManagerCanaccord Genuity Inc.New York NY(212) 389-8176------------------------------Original Message:Sent: 06-02-2019 09:23 PMFrom: Mahmoud AbdolrahimSubject: Execute a SQL Store Procedure in Script
How do I download or view the file How to run a Stored procedure in Automator Visual Process.docx?
Hi Matt,
Please see attached file.
Mo
If you click on the attached file it will be downloaded to the default download folder.
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
