Version check - "DELETE FROM..." syntax

IBM's flagship relational database management system
Post Reply Previous topicNext topic
jasand
Posts: 11
Joined: Fri Mar 12, 2010 5:41 pm
Skillset: JCL, COBOL, CICS, DB2
Referer: Internet

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.
Top
enrico-sorichetti
Global moderator
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Skillset: tso,rexx,assembler,pl/i,storage,mvs,os/390,z/os,
Referer: www.ibmmainframes.com

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
Top
NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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
Top
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “DB2”