Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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
This topic is locked: you cannot edit posts or make replies. Difference between EQUAL and EQUAL TO... jithinraghavan COBOL Programming 3 Thu Apr 19, 2018 2:22 am
No new posts ISMF Difference between volume count ... upendrasri IBM Tools 2 Tue Dec 05, 2017 12:40 pm
No new posts Finding difference between two PS fil... Vignesh Sid SYNCSORT 5 Mon Oct 30, 2017 1:13 pm
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts Difference between TWALENG and TWASIZE Arunkumar Chandrasekaran CICS 3 Tue Jan 03, 2017 12:57 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us