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

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

 

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 ?
cheers
enrico
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
enrico-sorichetti
Global moderator
 
Posts: 2728
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 140 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.
Regards
Nic

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


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post