Page 1 of 1

Version check - "DELETE FROM..." syntax

PostPosted: Wed Aug 09, 2017 7:22 pm
by jasand
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.

Re: Version check - "DELETE FROM..." syntax

PostPosted: Wed Aug 09, 2017 8:22 pm
by enrico-sorichetti
why not look Yourself at the relevant manuals to find out ?

Re: Version check - "DELETE FROM..." syntax

PostPosted: Wed Aug 09, 2017 8:27 pm
by NicC
Read the SQL Language Reference manual. At the beginning should be a chapter on changes between releases.