Re: RPG embedded SQL GROUP BY with cursor

Thank you Vern. Jon and Susan's PDF was a good starting reference for me. Plus, through the years I have worked with sql, albeit, from a defensive stance so I am not starting from scratch.

Recently I wanted to add some variety to my web site, and SQL seemed like a place to play in. I have to say, SQL impresses me.

On 1/22/2016 6:43 PM, Vernon Hamberg wrote:

Booth

Just to get a start in SQL can seem daunting. I started learning it
around 1990 using STRSQL and F4 a lot. That can give you a lot of the
basics - the WHERE clause, the ORDER BY clause, GROUP BY, HAVING, FROM,
etc.

I just took a look at www.w3schools.com - they have an SQL tutorial. It
will give you some real basics, and I think, at a quick glance, that
it's close enough to the standards that you won't be led too far astray.
There's a quick reference PDF there that looks quite good. There are a
couple things we don't have (SELECT TOP, TRUNCATE TABLE, and the EXISTS
example I've never used that way) - we may have equivalent statements.

I just went through a few pages - it looks really good for starting out.
You're already beyond SOME of it, but this should give you a good base
point.

once you have some of that down, there is the matter of programming with
it - embedded sql is covered in a manual on IBM's Knowledge Center in
the database manuals - i forget the name right now, but you'll maybe
need that.

HTH
Vern