The Details tab in the OpenESQL Assistant shows detailed information on the columns in a table. The columns on the Details tab describe the columns in the selected table as follows:
The column name of each column in the table. Notice that each column name is prefixed by the table alias. For example, a table with the name CustID shows on in the Column Name column as A.CustID. A tick in the box to the left of Column Name indicates that the column is currently selected.
The data type of the column. These are the data types used by the data source to which you are connected. The data type of a column must match the COBOL picture clause of the host variable that is used to pass values for that column to and from the data source.
OpenESQL Assistant can generate a copybook, tablename.cpy, in the current directory that declares all of the necessary host variables, matching them with COBOL picture clauses generated using column data types. See the topic Auxiliary Code for more details.
The total number of digits in numerical columns or the length of the column for text columns.
The number of digits to which the column is rounded, where relevant.
The value of the generated host variable for the column. Generated host variable names take the form:
:<table-name>-<column-name>
The value of the generated indicator variable for the column. Generated indicator variable names take the form:
:<table-name>-<column-name>-NULL