OxyGen Code Generator Overview. 4   Table of Contents. 4
Previous Topic: Configuring Stored Procedures. 4   Next Topic: Generating Source Code. 4

In this chapter, we will show how to generate stored procedure configurations.

1. Open OxyGen Code Management Studio.
2. In the Connect to Server dialog specify the Server Name (the default instance of SQL Server often uses the machine name), the Authentication mode, user credentials (if SQL Server Authentication is selected), and then click the Connect button.

Figure 27: Connection to Server dialog

3.       Click Processing\Stored Procedure Configuration Generator Wizard… menu item. The Stored Procedure Configurations Generator Settings wizard is displayed in “Figure 28: Stored Procedure Configurations Generator Settings database connectivity step”

Figure 28: Stored Procedure Configurations Generator Settings database connectivity step

4.       Click the Next button. The Database Stored Procedures step is displayed (“Figure 29: Stored Procedure Configurations Generator Settings. Database Stored Procedures step”). During this step select the stored procedures for which you want to generate configurations.

Figure 29: Stored Procedure Configurations Generator Settings. Database Stored Procedures step

5.       Click the Next button. The Resultset Assignment Strategy is displayed (“Figure 30: Stored Procedure Configurations Generator Settings. Resultset Assignment Strategy step”). During this step select the sequence of strategies to assign the stored procedure resultsets.

Figure 30: Stored Procedure Configurations Generator Settings. Resultset Assignment Strategy step

6.       Click the Finish button and the dialog “Figure 31: Stored Procedure Configurations Generator Confirmation dialog” is displayed. The selected stored procedures have to be executed in order to extract information required to generate configurations. If you want to generate configurations for selected stored procedures click the Yes button.

Figure 31: Stored Procedure Configurations Generator Confirmation dialog

7. The following screen shot shows the Stored Procedure Configuration Generator progress dialog.

Figure 32: Stored Procedure Configurations Generator dialog

8. On a successful configurations generation, the dialog “Figure 33: Generated Stored Procedure Configurations dialog” is displayed. This allows the user to view generated configurations, check configurations which user wants to save, change generated configurations and search for a particular stored procedure.

Figure 33: Generated Stored Procedure Configurations dialog

OxyGen Code Generator Overview. 4   Table of Contents. 4
Previous Topic: Configuring Stored Procedures. 4   Next Topic: Generating Source Code. 4