Re: Best Practices on DB2 SQL Databases

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

I think an issue is the whole mind set. Syntax is one thing -
understanding relational concepts, things like inner vs. outer,
cursors...things like that can be tough to get your head around. A
good SQL book (or some type of training) can be really valuable.

On Thu, Jan 15, 2009 at 10:50 AM,  <rob@xxxxxxxxx> wrote:
> As I've said, I've no problem with that, but don't stay there.  Buy a book
> and pursue other educational opportunities.
>
> Heck, if you limited your sql knowledge to RTVQMQRY and STRSQL prompter
> you'd never use a join - only a where clause.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:
> Vern Hamberg <vhamberg@xxxxxxxxxxx>
> To:
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> Date:
> 01/15/2009 10:37 AM
> Subject:
> Re: Best Practices on DB2 SQL Databases
> Sent by:
> midrange-l-bounces@xxxxxxxxxxxx
>
>
>
> I cut my SQL teeth on interactive SQL in the early '90s - it's an
> excellent tool for starting out, especially the prompting. Admittedly,
> IBM have not updated it even to handle JOIN syntax, but I can live with
> that. At least once you put JOIN syntax in, it does recognize which
> tables you are using, so you can get column lists.
>
> Now Navigator has the tool for running SQL statements but I've not seen
> a decent prompter there yet - QBE is a fantastic help in MS Access when
> I continued to sharpen my teeth. Now things like SQL Server and mySQL
> have tools that help you immensely - I do think IBM are a bit behind in
> this area - perhaps the Data perspective or QuantumDB can give us more
> what is needed - I've not had to go either of those routes yet, but they
> are recommended - well, the Data perspective can be a dog if you don't
> filter your connection enough!!!
>
> So one can decry some of the simple tools, but there are still beginners
> out here who could well benefit from their use.
>
> JMHO
> Vern
>
> DeLong, Eric wrote:
> > Scoff if you want, I really DID get my first exposure to RPG/400 by
> > reviewing Synon/2E generated code.  What else is one to do?  We were a
> > S36 shop (in the sun-blasted wastes of west Texas) that bought into the
> > Synon vision when moving to the AS400, though I was the only developer
> > there to ever use it for a production application.  No LUG, IBM was 60
> > miles away, no internet.  Synon was the only tutor I had at the time,
> > and I was grateful to have that....
> >
> > ...Ah the memories,
> > Eric DeLong
> >
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Walden H. Leverich
> > Sent: Thursday, January 15, 2009 8:23 AM
> > To: Midrange Systems Technical Discussion
> > Subject: RE: Best Practices on DB2 SQL Databases
> >
> >
> > > 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.
> >
> > Well, I know RPG because I used Synon... so I'm good right? :-)
> >
> > -Walden
> >
> > --
> > Walden H Leverich III
> > Tech Software
> > (516) 627-3800 x3051
> > WaldenL@xxxxxxxxxxxxxxx
> > http://www.TechSoftInc.com
> >
> > Quiquid latine dictum sit altum viditur.
> > (Whatever is said in Latin seems profound.)
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> > list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> > unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> > moment to review the archives at http://archive.midrange.com/midrange-l.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.