Micro Focus Visual COBOL 3.0 for Visual Studio 2017
>
Programming
>
Data Access
>
Database Access
>
How to
>
OpenESQL Assistant
OpenESQL Assistant
To add a column to a query
To add all columns in a table to a query
To add an XML data source
To add or update a SQL CLR Stored Procedure
To change a SELECT (cursor) query to do an array FETCH
To close a query
To close the OpenESQL Assistant
To connect to a data source
To connect to a different data source
To create a table join
To create an SQL query
To create a SQL CLR stored procedure query
To create a TSQL stored procedure query
To disconnect from a data source
To display column details
To embed an SQL query into a program
To generate a DCLGEN copybook
To generate a DELETE statement
To generate a SELECT (cursor) statement
To generate a SELECT (singleton) statement
To generate a SELECT DISTINCT (cursor) statement
To generate a SELECT DISTINCT (singleton) statement
To generate a DECLARE DATATABLE statement
To generate an INSERT statement
To generate an UPDATE statement
To generate and embed auxiliary code
To perform an aggregate function
To refresh the list of data sources
To remove a table from a SELECT query
To run a query
To set OpenESQL Assistant options
To sort returned data (an ORDER BY clause)
To specify search criteria (a WHERE clause)
To start the OpenESQL Assistant
To view data source properties
Parent topic:
How to
