|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 6th, 2003, 03:38 AM
|
||||
|
||||
|
SQL-Standard???
Hi there!
I'm now working with Db2 now and found tons of new SQL commands. But the problem is: Some db2 SQL statements aren't available in mysql/Oracle ... and vice versa. So i wondered where i can find a list of SQL commands that are available in all databases. TIA
__________________
Lebowski: Isn't that what makes a man? Dude: Mmm, sure. That and a pair of testicles.
|
|
#2
February 6th, 2003, 04:09 AM
|
|||
|
|||
|
The problem with SQL is that almost all vendors add extensions and only implements a subset of ANSI SQL 99. Especially Mysql lacks a large amount of features that is part of the standard.
You can check that your queries are ANSI SQL 99 compliant by using the validator at http://developer.mimer.se/validator/parser99/index.tml Even if your queries adheres to standard there is no warranty that they are portable between different DBMS.
|
|
#3
February 6th, 2003, 04:42 AM
|
||||
|
||||
|
Argg
Hm yeah that was my guess to.
The tool you mentioned is geat but our Db2 (Os390) does not like Functions like ADD, which even complie with Ansi 92. Regards
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > SQL-Standard??? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
