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

Define a post-build event

1. In the Properties window, expand Micro Focus > Build Configurations > Events.
2. In the Post build event command line field, type the following command:

   DSN SYSTEM(HCODemo) @"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. Eclipse executes this event immediately after building the application, automatically binding the application at that time.

3. Click Apply and Close. Eclipse builds the native application automatically.

View the contents of the bind script file

• From the COBOL 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.

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.