- Requirements 
                  		  
               
- Before attempting this tutorial, you must complete the following tutorials in the order listed: 
                  			 
                   
                     				
                     - Tutorial: Create a SQL Server Database 
                        				
                     
- Tutorial: Create and Configure 
                           					 a Visual Studio Project 
                        				
                     
- Tutorial: Set OpenESQL Assistant Configuration Options 
                        				
                     
- Tutorial: Catalog a Connection 
                        				
                     
- Tutorial: Build and Test a Query 
                        				
                     
- Tutorial: Generate and Embed an SQL Program 
                        				
                     
- Tutorial: Provide Additional Code 
                        				
                     
 
- Add the Generated Copybook to the Project 
                  		  
               
-  While the OpenESQL Assistant generated and saved the copybook necessary to compile the application, it does not automatically
                  add the file to the current project. The copybook must be part of the project to be included in the compiled application.
                  
                  			 
                   
                     				
                     - From the Solution Explorer, right-click the 
                        				  OESQLAssistantTutorial project and select 
                        				  Add > 
                        				  Existing Item. 
                        				
                     
- Select 
                        				  EMP.cpy; then click 
                        				  Add. 
                        				  
                        The 
                           					 EMP.cpy copybook is added to the project. 
                           				  
                         
 
- Add a Break Point 
                  		  
               
- The program sends output to the console, and you want the application to pause at the point where you can see the output.
                  
                  			 
                   
                     				
                     - In the COBOL Editor, scroll down to the following statement: 
                        				  EXEC SQL DISCONNECT CURRENT END-EXEC 
- Place your cursor on the statement; then press 
                        					 F9 to toggle a break point. 
                        				
                     
- Click 
                        				  Save All ( ) to ensure that everything in the project is up to date. ) to ensure that everything in the project is up to date.
- Close any open tabs including the COBOL Editor and the OpenESQL Assistant.
                        				
                     
 
- Build the Application 
                  		  
               
-  
                  			 
                   
                     				
                     - From the Solution Explorer, right-click the 
                        				  OESQLAssistantTutorial project and select 
                        				  Build. 
                        				
                     
 
- Debug the Application 
                  		  
               
-  
                  			 
                   
                     				
                     - Press 
                        				  F5 to start debugging. 
                        				  
                        When execution reaches your breakpoint, Visual Studio places the query output into a console window.
                           				  
                         
- If the console is not visible, minimize 
                        				  the Visual Studio IDE. You should see the console output. 
                        				
                     
- Press 
                        				  F5 again to complete the debugging process. 
                        				
                     
 
This completes the OpenESQL Assistant tutorials.