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 generate and embed auxiliary code
- Open the project that contains the program into which you want to embed the SQL.
- Open the appropriate program in the program editor.
- Place your cursor at the point in your program where you want the auxiliary code to appear.
- In the OpenESQL Assistant, click the Auxiliary Code tab.
- Click EXEC SQL, EXEC ADO connected, or EXEC ADO disconnected, depending on the type of code you want to generate.
- If you want to specify a data set name for EXEC ADO, type the data set name into the Dataset name field. Optional.
- Click Insert Query into Current Program
Note: To enable OpenESQL Assistant to generate EXEC ADO code, be sure to check the Generate EXEC ADO option when you set options for OpenESQL.