ID Number: Q72860
1.10
OS/2
docerr
Summary:
SYMPTOMS
Page 38 of the "Embedded SQL for COBOL Programmer's Reference"
incorrectly states that the SELECT statement for positioned updates
and deletes cannot contain DISTINCT, ORDER BY, GROUP BY, HAVING, a
join, an expression in the SELECT list, or a FROM clause
identifying a table or view that is also used in a subquery.
CAUSE
This is not correct ; the only restrictions are that the updated
column must be from the first table in the FROM clause and that the
column must exist in the table; that is, you cannot update an
expression.
STATUS
Microsoft is aware of this documentation error and will update a
future version of the manual to reflect this information.