Selecting Columns

Once you have generated your initial query code, you can select one or more columns to process in your query. You can add columns to your query by checking the box that appears next to a column name in the tree view. Selected columns appear in the tree view with a check mark next to the column icon, Checked Column. Each column name is prefixed by its alias (for example, A.CustID, A.Company). This enables you to distinguish the columns in one table from those in another.

Note: If the name generated from the column name (including any prefixes and suffixes) is longer than 31 characters or contains characters that are illegal in COBOL, OpenESQL generates a host variable using the column number (for example, COL005) rather than the column name.