Re: Cool but ugly SQL

On 6/19/06, vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx> wrote:

I know what you mean about the reference manual - but it is actually
pretty good. I've read Celko's book - fascinating and useful eventually, I
think. It is not applied to any particular flavor of SQL, and some of what
he suggests might not work the same way on the iSeries.

"particular flavor"?  I thought SQL was supposed to be something like Java,
write once, run everywhere?  Otherwise, what are the standards for?  I think
I understand that AS/400, er, eServer iSeries, er, i5, er, System i has its
own SQL extensions, right?  But you're suggesting that might appear in
Celko's book might not apply to Series i?

Maybe take a look at www.iseries.ibm.com/db2 and rummage around. Then, in

the V5R4 version of Infocenter, under Database, is a "Database information
finder" that is quite neat, as it is organized in several ways - by tasks,
by topics, by examples, etc. The above db2 link probably has a link to the
infocenter stuff.

I need to spend some time looking through this stuff.  Thanks for the
reference, Vern!

Then you can always google for things like "sql tutorial" and get a lot of

good stuff from basic to more advanced. One nice site is www.w3schools.comthat 
has stuff on all kinds of topics, from SQL to HTML to Javascript to
XML, all in manageable chunks.

Doesn't this get into the same "SQL flavor" issues you raised with Celko?

Enjoy!! and welcome to the black-box world of SQL!


Thanks!  I look forward to the day when I can contribute to SQL discussions.

- Dan