To generate and embed auxiliary code

  1. Open the project that contains the program into which you want to embed the SQL.
  2. Open the appropriate program in the program editor.
  3. Place your cursor at the point in your program where you want the auxiliary code to appear.
  4. In the OpenESQL Assistant, click the Auxiliary Code tab.
  5. Click EXEC SQL, EXEC ADO connected, or EXEC ADO disconnected, depending on the type of code you want to generate.
  6. If you want to specify a data set name for EXEC ADO, type the data set name into the Dataset name field. Optional.
  7. Click Insert Query into Current ProgramCreate New Query
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.