Previous Topic Next topic Print topic

Micro Focus Visual COBOL 2.3 for Visual Studio 2015 > Programming > Data Access > Database Access > How to... > OpenESQL Assistant > To generate a SELECT DISTINCT (singleton) statement

To generate a SELECT DISTINCT (singleton) statement

  1. Start the OpenESQL Assistant.
  2. Connect to a data source.
  3. Check the box next to a table name.
  4. Click SELECT DISTINCT (singleton), then click OK.
  5. Check the box next to each column you want to include in the SELECT statement.
  6. Further define the query using the Search Criteria feature. Optional.
Parent topic: OpenESQL Assistant
Related concepts
OpenESQL Assistant
Related tasks
To specify search criteria (a WHERE clause)
To sort returned data (an ORDER BY clause)
Previous Topic Next topic Print topic