Problem:
A table in XDB has a column with the same name as a reserved word (ex: delete)
Using a select statement in your COBOL program like:
SELECT delete
FROM mftest
will get a compiler error:
COBES0100S Incorrect SQL statement syntax near DELETE
Resolution:
In the SELECT statement to qualify the column with the table name should resolve this issue:
SELECT mftest.delete
FROM mftest
Esp. using SQLSERVER to enclose the column names in square brackets:
SELECT [delete]
FROM mftest
Old KB# 4379
