RE: Embeded SQL Query - Possible to make it in RPGLE.

I don't know what preconceived notions have to do with this particular
statement.  It's big, complex, and even the comments say it's hard to
understand.

My guess is that working with an SQL expert might help reduce some of
the complexity of the statement.  I know that using a MIN to get a
single value like description just isn't right; you need to be doing
some grouping at the very least.

As to the entire concept of a single SQL being this complex, well that's
something you have to decide whether makes sense.  I'd have to guess
there are less than a dozen people on this list who could modify that
statement to add, say, a new report type.  If your company is flush with
people who can write that sort of code then great; if there's only one
you have an exposure.

It's just business, not religion.

Joe

> From: rob@xxxxxxxxx
> 
> Actually, I didn't write it.  It was written by our newest programmer
> here.  A gentleman we hired because the rest of his family does good
> programming.  We hired him away from an mechanical engineering job he
> worked at.  He learned embedded SQL from reading the manuals available
at
> infocenter, and frankly, I've learned some cool stuff from him.
Sometimes
> it's nice to come in fresh without any preconceived notions.