Tutorials: SQL Server COBOL Stored Procedures

Using the SQL CLR Integration feature in Visual COBOL, you can code stored procedures, user-defined functions, aggregates, triggers, and user-defined types that contain EXEC SQL statements, and compile the code using the OpenESQL preprocessor.

The scenario that represents the most common and best use of the SQL CLR Integration feature in Visual COBOL is that of creating a SQL CLR stored procedure for OpenESQL and calling it from an OpenESQL application. Here, we provide a series of tutorials that lead you through this processes.

Tutorial Requirements

To complete the SQL Server COBOL Stored Procedures tutorials, you must have the following software installed:

  • A more advanced edition of Visual Studio such as Professional, Enterprise or Community Edition. This tutorial does not work with the Visual Studio Shell.
  • Microsoft SQL Server 2012 or later, Enterprise or Developer Edition, including the SQL Server Management Studio.
  • Microsoft SQL Server Data Tools.

Additional requirements that apply to specific tutorials appear in the Requirements section of each.

Order

Complete these tutorials in the following order: