Version check - "DELETE FROM..." syntax

IBM's flagship relational database management system

Version check - "DELETE FROM..." syntax

Postby jasand » Wed Aug 09, 2017 7:22 pm

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.
Posts: 11
Joined: Fri Mar 12, 2010 5:41 pm
Has thanked: 1 time
Been thanked: 0 time

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

Postby enrico-sorichetti » Wed Aug 09, 2017 8:22 pm

why not look Yourself at the relevant manuals to find out ?
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
Global moderator
Posts: 2999
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

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

Postby NicC » Wed Aug 09, 2017 8:27 pm

Read the SQL Language Reference manual. At the beginning should be a chapter on changes between releases.
The problem I have is that people can explain things quickly but I can only comprehend slowly.

These users thanked the author NicC for the post:
jasand (Wed Aug 09, 2017 10:08 pm)
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Return to DB2


  • Related topics
    Last post