|
Dan, that's not what he said, it was "Never underestimate the power of the Dark Side". And to keep this on topic: I've never _ever_ used OPNQRYF. Whenever I see it, I go all eeeewwwww. Peter Colpaert Application Developer PLI - IT - Kontich, Belgium ----- Yoda of Borg are we. Futile is resistance, assimilated will you be. ----- Dan <dan27649@xxxxxxxxx> Sent by: midrange-l-bounces@xxxxxxxxxxxx 19/06/2006 16:33 Please respond to Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> To "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx> cc Subject Re: Cool but ugly SQL I can still hear James Earl Jones speaking the line "Do not underestimate the power of the force." I look at SQL these days in the same "light" that I remember seeing OPNQRYF 15 years ago. "Awesome! You can do *that*?!?!?" So much to soak in. (Since I bring it up, I wonder if anyone uses OPNQRYF in new development anymore?) I will give your examples a run-through when I get a chance. (Thanks!) I recommend the SQL Reference on IBM's site for more on this. Maybe it's just me, but I find the SQL Reference useful only when you *know* what you're looking for. Maybe it's just the nature of the beast, 2000 ways to skin a cat and all that, but in the case of the questions "Can I do this?" or "How do I do that?", the SQL Reference more often then not leads me on a wild goose chase. A colleague here has "Joe Celko's SQL for Smarties" that I've been meaning to have a look at, but it's also labeled "Advanced SQL Programming", so I don't know. - Dan
As an Amazon Associate we earn from qualifying purchases.
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.