× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2009

RE: Best Practices on DB2 SQL Databases

Walden,

I tend to agree with you. Learning DDL didn't take too much. And you're
right about DDS being so limited.
Really learn DDL. It will help you:
1 - Better define data.
2 - Use more features like constraints and stuff that can't be done in DDS
but only can be bolted on.
3 - Become more marketable.
4 - Understand other platforms better.

Don't be like the people who limit their SQL learning to only that which
can be easily prompted within STRSQL or from RTVQMQRY ALWQRYDFN(*YES).
Really learn the tool. Doing the simple way is like saying you know RPG
because you generated an inquiry screen from within a CASE tool like
AS/SET once.

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.