Define and Verify a Post-Build Event that Binds the Application

Define a post-build event

1. In the Properties window, click the COBOL tab; then click Build Events.
2. In the Post build event command line field, type the following command:

   DSN SYSTEM(HCODemo) @"$(ProjectDir)FunctionEmulation.hcodsn"

   This command calls the DSN Bind utility, specifies the SQL database connection to use, and states the location and name of a bind script file. Visual Studio executes this event immediately after building the application, automatically binding the application at that time.

3. Click OK to close the Build Events dialog box.
4. Close the Properties window.

View the contents of the bind script file

• From the Solution Explorer, open and review the contents of FunctionEmulation.hcodsn. This bind script file contains one BIND PLAN command that binds the FunctionEmulation member into a plan named FunctionEmulation.

Build and bind the applcation

1. From the Solution Explorer, rebuild the FunctionEmulation project, thereby generating a DBRM for the application and automatically binding it to the DBRM using the post-build event.
2. Verify that the project built successfully.

Verify the results

1. Using Microsoft SQL Server Management Studio, connect to your SQL Server instance.
2. On the Object Explorer, expand Databases > HCO_Test > Programmability > Stored Procedures to see the stored procedures HCOSS created when you executed your packages and plan.
3. Open one of the stored procedures that contains PLN as part of its name.

   In this, you see your application code making the calls to the user-defined functions.