Re: Interactive SQL question

[Phil Groschwitz <sublime78ska@xxxxxxxxx>]

There's a new book - SQL/400 - by Paul Conte and Mike
Cravitz.  Well worth the $52.

Phil

--- Dennis Munro <DMunro@badgerminingcorp.com> wrote:
> I'm running V4R5M0 & a beginner at SQL.
> 
> I am trying to find some information on how to
> "code" column totaling. I
> have a report that selects qty, price, (qty * price)
> from a file but I would
> like to total the three columns.  Looked through the
> Midrange archieves but
> you get tired of looking through 278 entries after
> 25 & they don't pertain
> to my question.
> 
> I found one book on the on-line info center named
> "SQL Programming Concepts"
> that has a very "brief" section on interactive SQL. 
> But nothing that gives
> any programming examples.
> 
> I've talked to the local technical college &
> Interactive SQL is the only
> AS/400 based SQL class they teach & that is probably
> what I will do.  The
> instructor said the class is very basic & I've
> fooled around enough to
> wonder about a waste of time (16 weeks) & money. 
> All I have to do is get a
> couple of hints & it would be worth the effort so I
> think it will happen.
> 
> Again, all I want to do is find some information on
> Interactive SQL.  How to
> total a column is what I am trying to accomplish.
> 
> Dennis Munro
> 
> "I love deadlines.  I especially like the whooshing
> sound they make as they
> go flying by."  Dilbert's Words Of Wisdom:
> 
> Badger Mining Corporation
> www.badgerminingcorp.com
> dmunro@badgerminingcorp.com
> (920) 361-2388
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to
> MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to
> MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list
> owner/operator: david@midrange.com
> +---


__________________________________________________
Get personalized email addresses from Yahoo! Mail - only $35 
a year!  http://personal.mail.yahoo.com/
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---