Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL Standard
- Thread starter festus
- Start date
Follow SQL92 standards. The vendors usually provide a list of non-standard SQL (eg "connect by" in oracle). Just do straight SQL insert, select, update, delete (CRUD) without getting too fancy and you should be fine. The key is to test you app on the various platforms, but to my knowledge DB2 and Oracle are pretty comparable in regards to the fundemental CRUD stuff.
I choose to differ...<br>
<br>
<br>
the reason is this...<br>
database like DB2 and Oracle have certain <br>
extra features that allows queries to run<br>
faster ...<br>
<br>
so u should look into design patterns<br>
that will dynamically load depending on<br>
environments...<br>
<br>
something like factory classes etc...<br>
<br>
its the design... festus..<br>
regardless of how technogy moves..<br>
the fundamentals is still the same...<br>
<br>
<br>
<br>
<br>
the reason is this...<br>
database like DB2 and Oracle have certain <br>
extra features that allows queries to run<br>
faster ...<br>
<br>
so u should look into design patterns<br>
that will dynamically load depending on<br>
environments...<br>
<br>
something like factory classes etc...<br>
<br>
its the design... festus..<br>
regardless of how technogy moves..<br>
the fundamentals is still the same...<br>
<br>
<br>
- Status