Created On: 26 October 2012
Problem:
Customer using OpenESQL Assistant Tool in Visual COBOL to generate a SELECT query for a table named CUST-TABLE.
When the table is selected and they select to generate a SELECT INTO query OpenESQL displays the following error and no column names are displayed.
"Cannot Find Column ColumnOrdinal"
What is causing this?
When the table is selected and they select to generate a SELECT INTO query OpenESQL displays the following error and no column names are displayed.
"Cannot Find Column ColumnOrdinal"
What is causing this?
Resolution:
OpenESQL Assistant will display this error when you are generating a query for a table that contains columns that have the hyphen character in the name:
Example:
CUST-NAME
CUST-COMPANY
CUST-DATE
If you have a table containing columns that use the hyphen character then you must quote the table and column names. You can do this by selecting Tools > Options > Micro Focus COBOL > OpenESQL Assistant and changing the quote table and column names to true:
Example:
CUST-NAME
CUST-COMPANY
CUST-DATE
If you have a table containing columns that use the hyphen character then you must quote the table and column names. You can do this by selecting Tools > Options > Micro Focus COBOL > OpenESQL Assistant and changing the quote table and column names to true:
Old KB# 36517
#netexpress
#EnterpriseDeveloper
#MFDS
#COBOL
#VisualCOBOL
#Enterprise
#StudioEnterpriseEdition
