Rocket® Visual COBOL® (formerly a product of Micro Focus or formerly a product of Open Text) documentation, created before Rocket Software acquired certain products from OpenText, may include outdated references to "Micro Focus" or "OpenText", both of which are trademarks of OpenText or its affiliates. Rocket Software is not affiliated with Micro Focus or OpenText and has since rebranded these products as Rocket® products. You may also encounter outdated links in this documentation. If you do, please contact Rocket Support (support@rocketsoftware.com) for assistance.
To create a TSQL stored procedure query
- In your OpenESQL Assistant Options, set Query > Type Stored Procedure to TSQL.
- Start the OpenESQL Assistant.
- Connect to a Microsoft SQL Server data source.
- Check the box next to a table name.
- Click a query type from the list.
- Check Generate Query as a TSQL Stored Procedure.
- In the SP name field, type a name for the stored procedure. Alternatively, accept the default value.
- Click OK.
- Continue to build your query.