Enterprise Developer provides a number of demonstration applications for HCOSS. You can access these via the Mainframe Samples Browser. For instructions on how to start the Mainframe Samples Browser, see
To start the Samples Browser.
The demonstration files are located in the
%PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\Mainframe\SQL\hcoss directory.
Each sample application comes with a
Readme file to explain how to use the application.
The HCOSS demonstration applications all produce a console log displaying their progress. They all terminate on receipt of an error, after displaying an error message.
- HCOSS - JCL Calling SP Using SPD File
- Walks you through the process of invoking a native COBOL program using JCL, and calling a SQL Server SQL CLR stored procedure that returns the results back to the calling COBOL native program.
The SQL CLR stored procedure used in this demonstration was generated using the Generate SPD File tool.
- HCOSS - JCL Calling SP with Group Parameters Using SPD
- Walks you through the process of invoking a native COBOL program using JCL, and calling a SQL Server SQL CLR stored procedure that returns the results back to the calling COBOL native program.
The SQL CLR stored procedure used in this demonstration was generated using the Generate SPD File tool, and is called using group variables.
- HCOSS - Array Insert
- Demonstrates how array inserts work with SQL Server when using mainframe DB2 syntax.
- HCOSS - Function Emulation
- Demonstrates how to add math functions to SQL Server that emulate standard math functions in DB2.
- HCOSS - Labeled Durations
- Demonstrates how HCOSS manages DB2 date formats and labeled duration calculations. SQL Server does not support labeled calculations directly. HCOSS handles the conversion to T-SQL to emulate DB2 labelled duration syntax.
- HCOSS - TwoPackageSet
- Demonstrates how to use HCOSS to switch package sets and alternate fetching data using a single cursor name. It also demonstrates how, with HCOSS, you can bind the application using HCOSS Manage Packages and Plans tool.
- HCOSS - Multiple Result Sets
- Shows how to create a Microsoft SQL Server SQLCLR Stored Procedure with multiple result sets and then access them from client program using mainframe DB2 syntax.
- HCOSS - SQL CLR Stored Procedure Call
- Demonstrates how to call a SQL CLR stored procedure using a DB2 style stored procedure definition (defined with an SPD file) from a COBOL console application.
