Call SQL Server Stored Proc From JD

[Esperanza]

Hello JDE Experts !
Is there a business fuction (or something else) to call an SQL Server Stored Proc From JD.
Thanks in advance !!

 

[wadedaw]

You could use ISQL. Simply put an ISQL statement in a .bat file and call that file using the "Run Executeable" system function or the "Run External Program" business function.

You can find information about using isql here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_isql_8r39.asp