Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Difference between DB2 SQL and ANSI SQL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
boo_sri

New User


Joined: 26 Jul 2005
Posts: 36
Location: charlotte

PostPosted: Wed Jan 23, 2008 4:33 am    Post subject: Difference between DB2 SQL and ANSI SQL
Reply with quote

Hi,
one of our application is using ANSI SQL and they want to convert it into DB2 SQL standard. So please answer the following asap:

1. what is the diff b/w ANSI SQL and DB2 compatible SQL?
2. How to convert it?
3. What will be the benefits?


Database Details:
Version : Db2 v8.1 for z/OS (compatibilty mode)
Processor: Z900 series
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Wed Jan 23, 2008 5:17 am    Post subject:
Reply with quote

Try running it without converting. Most SQL is just SQL. They should be compatible as long as you didn't do anything funky.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jan 23, 2008 8:33 am    Post subject:
Reply with quote

Hello,

Which database system is currently running?
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Wed Jan 23, 2008 9:09 am    Post subject:
Reply with quote

ANSI isn't a database vendor, it is the American National Standards Institute. DB2 SQL most likely conforms to one of the actual ANSI SQL standards but also extends it.

http://en.wikipedia.org/wiki/SQL#Standardization
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jan 23, 2008 8:26 pm    Post subject:
Reply with quote

Hi Steve,

Yes, it is a standard rather than a product, but i was just wondering on which database engine the "ANSI SQL" is currently running. . .
Back to top
View user's profile Send private message
boo_sri

New User


Joined: 26 Jul 2005
Posts: 36
Location: charlotte

PostPosted: Thu Jan 24, 2008 2:50 am    Post subject:
Reply with quote

Hi Dick,
The database engine is DB2 and is running on a mainframe server (z900 series).

Version: DB2 v8.1 for z/os (compatibility mode)
H/w : Z900 series
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Jan 24, 2008 8:56 am    Post subject:
Reply with quote

Hello Boopathy,

If the application is already successfully running on DB2 (i misread/misunderstood that from the initial post, my apologies icon_redface.gif ), is there a need for a conversion?
Back to top
View user's profile Send private message
boo_sri

New User


Joined: 26 Jul 2005
Posts: 36
Location: charlotte

PostPosted: Thu Jan 24, 2008 8:29 pm    Post subject: Reply to: Difference between DB2 SQL and ANSI SQL (urgent)
Reply with quote

Basically i need the exact difference beween the ANSI SQL and DB2 SQL. I heard that DB2 compatible SQL will give more flexibility and performance compared to the ANSI Sql.
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Thu Jan 24, 2008 8:32 pm    Post subject:
Reply with quote

You'll need to compare the DB2 v8.1 SQL manual to the ANSI spec that it is implemented against.
Back to top
View user's profile Send private message
boo_sri

New User


Joined: 26 Jul 2005
Posts: 36
Location: charlotte

PostPosted: Fri Jan 25, 2008 3:07 am    Post subject: Reply to: Difference between DB2 SQL and ANSI SQL
Reply with quote

Steve -

can any one forward me those docs to my id: persnal e-addr removed
Back to top
View user's profile Send private message
stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Fri Jan 25, 2008 3:12 am    Post subject:
Reply with quote

DB2
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/DSNSQJ10/CCONTENTS?

The link I provided you to Wikipedia states the ANSI Standard is not freely available, however a late draft of SQL 2003 is linked from there.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm
No new posts Sticky: difference between ... DUMMY ... and ... enrico-sorichetti JCL & VSAM 0 Mon Oct 17, 2016 4:31 pm
No new posts Difference space showed for TS and it... autobox DB2 1 Thu Apr 14, 2016 1:07 pm
No new posts Difference Between CICS WebSupport an... sachinji84 CICS 1 Mon Mar 07, 2016 7:25 pm
No new posts Difference between -180 and -181 with... deepak_shrivastava DB2 4 Wed Jan 06, 2016 10:00 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us