Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

> ## Defining native stored procedures to the Progress 4GL

> The first time you run a stored procedure, the data-source management system creates an execution plan for it and stores the plan in the database. The next time you run the stored procedure, it runs the precompiled procedure, assuming it is still cached in the database. This makes access to the database quicker and more efficient than when you access it with new queries each time.

> The DataServer allows you to use Progress 4GL to run native a MS SQL Server stored procedures. All pre-defined stored procedures initiated on behalf of the MS SQL Server are executed from within Progress 4GL, using the `RUN STORED-PROCEDURE` statement. You define specific 4GL language elements to the `RUN STORED-PROCEDURE` statement to match the profile or signature of your native stored procedure. You can also provide additional 4GL statements subsequent to the `RUN STORED-PROCEDURE` statement to handle result sets from stored procedures.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095