RE: Big, Honking SQL Statement

[michael@xxxxxxxxxxxxxxxxxx]

Thanks...I took a look at Sorcerer's and see how and why it's used.

> -------- Original Message --------
> Subject: RE: Big, Honking SQL Statement
> From: rob@xxxxxxxxx
> Date: Wed, December 07, 2005 8:00 am
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> SQL-CLI = Structured Query Language Call Level Interface.
> 1 - There's a section on this in the InfoCenter
> 2 - There's some coverage of this in the RPG Sorcerer's Redbook.
> Basically used by a few people:
> - Those who can't get their bosses to pop for 5722-ST1.
> - Those running obsolete versions of OS/400 and who are frustrated with 
> precompiler issues that have been mostly resolved since V5R3.
> - Those who'd rather spend the extra time coding CLI (vs the ease of 
> imbedded SQL) than spend some time with an attractive member of the 
> opposite sex
> - I think there might be one or two obscure function only available with 
> CLI versus imbedded sql
> - A strange software house that wants to pi$$ off 95% of their customers 
> who modify their code who now have to learn CLI versus easy imbedded sql 
> in order for that same software house to sell packages to the 5% of their 
> customer base that doesn't want to pop for 5722-ST1.
> 
> Rob Berendt
> -- 
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
> 
> 
> 
> 
> 
> michael@xxxxxxxxxxxxxxxxxx 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 12/07/2005 06:03 AM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> 
> 
> To
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> cc
> 
> Fax to
> 
> Subject
> RE: Big, Honking SQL Statement
> 
> 
> 
> 
> 
> 
> Hmmm...what do you mean, passing it directly into the CLI? How would one
> do that?
> 
> > -------- Original Message --------
> > Subject: Re: Big, Honking SQL Statement
> > From: "James H H Lampert" <jamesl@xxxxxxxxxxx>
> > Date: Tue, December 06, 2005 8:50 pm
> > To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> > 
> > Or you could always, if you're programmatically generating 
> > a big honking SQL statement (something I've grown rather 
> > familiar with in the past few months), you can pass it 
> > directly into the CLI.
> > 
> > Not that this option has a whole lot of relevance to the 
> > matter at hand.
> > 
> > But so far as I'm aware, the CLI is there no matter how 
> > severely stripped the OS is, much the same way the runtime 
> > support needed for both RPG and C is always there.
> > 
> > --
> > JHHL
> > -- 
> > 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.