OxyGen Code Generator Overview. 4   Table of Contents. 4
Previous Topic: Specifying View Processing Instructions. 4   Next Topic: Configuring Stored Procedures. 4

In this chapter, we will show how to generate Virtual Views.

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 13: Connection to Server dialog

3.       Click Processing\Virtual Views Generator Wizard… menu item. The Virtual Views Settings wizard is displayed in “Figure 14: Virtual Views From Stored Procedures Generation Settings dialog. Database Connectivity step”.

Figure 14: Virtual Views From Stored Procedures Generation Settings dialog. Database Connectivity step

4.       Click the Next button. The Database Stored Procedures step is displayed (“Figure 15:  Virtual Views from Stored Procedures Generation Settings dialog. Database Stored Procedures step”). During this step select the stored procedures used to generate the virtual views. If you want to generate virtual views from generated stored procedures check Show Generated Stored Procedures option.

Figure 15:  Virtual Views from Stored Procedures Generation Settings dialog. Database Stored Procedures step

5.       Click the Finish button and the dialog “Figure 16: Virtual Views Generation Confirmation dialog” is displayed. The selected stored procedures have to be executed in order to extract the virtual views information. If you want to generate virtual views click the Yes button.

Figure 16: Virtual Views Generation Confirmation dialog

6. The following screen shot shows the Virtual Views Generator progress dialog.

Figure 17: Virtual Views Generation progress dialog

7. On a successful virtual views generation, the dialog “Figure 18: Generated Virtual Views Explorer dialogExplorer dialog” is displayed. This allows the user to view generated Virtual Views and check virtual views which user wants to save, rename names of virtual views and search for a particular virtual view.

Figure 18: Generated Virtual Views Explorer dialog

OxyGen Code Generator Overview. 4   Table of Contents. 4
Previous Topic: Specifying View Processing Instructions. 4   Next Topic: Configuring Stored Procedures. 4