Micro FocusĀ Visual COBOLĀ 3.0 for Visual Studio 2017
>
Programming
>
Data Access
>
Database Access
>
Reference
>
OpenESQL
>
User Interface Reference
>
OpenESQL Assistant
>
Sort tab
Sort tab
Columns in SELECT
A list of columns available for inclusion in the SELECT statement.
Asc
Sort alphabetically by first letter of the column name in ascending order.
Desc
Sort alphabetically by first letter of the column name in descending order.
Insert Sort String
Move the defined sort string to the
Columns in ORDER BY
list.
Remove Sort String
Remove the selected sort string from the
Columns in ORDER BY
list.
Columns in ORDER BY
Sort strings inserted into your query.
Use integers for column names
Generate the integer value of the column instead of the column name.
Note:
Column names are displayed on the
Columns in ORDER BY
list regardless of the setting for
Use integers for column names
.
Parent topic:
OpenESQL Assistant
Related concepts
OpenESQL Assistant
Related tasks
To sort returned data (an ORDER BY clause)