IBM Mainframe Forum

Dear All, Recently our organization had a DB2 version upgrade to v12.0, and while executing the DELETE query, we observe the below behavior.
Syntax 1: DELETE <<table name>.......
Syntax 2: DELETE FROM <<table name>.......

Both the above syntax are executing fine in the current DB2 12.0 environment. But, Syntax 1 was not executing in our earlier version (DB2 10.1 z9 server). We would like to understand if this behavior is really connected to the version upgrade. Or can there be any other reason? Kindly advise.

why not look Yourself at the relevant manuals to find out ?

Read the SQL Language Reference manual. At the beginning should be a chapter on changes between releases.

These users thanked the author NicC for the post:

jasand (Wed Aug 09, 2017 10:08 pm)