RE: SQL

["Haas, Matt" <Matt.Haas@xxxxxxxxxxx>]

That means it's building an index on the fly.

If you exit from interactive SQL, type in STRDBG UPDPROD(*YES), go back and run 
your query again, your job log will show you why it did this (and how long it 
took) and mostly likely give an index recommendation.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Douglas W. Palme
Sent: Thursday, March 31, 2005 4:50 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: SQL


That helped, thanks, another question kinda related, I noticed that when the 
query starts it displays the following: "Query Running.  Building Access 
Path for file IMPILN00 in ILMOLIB"

Can someone explain what that means building access path?


On Thu, 31 Mar 2005 13:43:20 -0800, Tony Carolla wrote
> Try this:
> 
> select ilnsoldto, sum(ilneprice) from impiln00 group By ilnsoldto
> 
> On Thu, 31 Mar 2005 13:40:20 -0800, Douglas W. Palme
> <dpalme@xxxxxxxxxxxxxxxxxxxxx> wrote:
> > As a follow up to the questions I had the other day, I've ordered the
> > appropriate license key for the SQL and have started working on learning
> > embedded sql to use with my rpg.
> > 
> > Needless to say, it'll delay some reports a bit but I think in the long 
run
> > it'll help.
> > 
> > One question I do have, I am running the sql interactive query and I am 
just
> > playing with it a bit, but have run into a problem that maybe one of you 
can
> > help me out with; considering the slightly different syntax between sql 
for
> > the iSeries and what I am used to.
> > 
> > I have a PF that cotnains among other fields, ilneprice (which contains
> > extended price amount), and a ilnsoldto field which is a reference field 
for
> > the customer number.
> > 
> > When I run 'select ilnsoldto' by itself it runs fine, when I run sum
> > (ilneprice) by itself its fine but when I run the following command it 
tells
> > me the ilnsoldto field is incorrect:
> > 
> > 
> > 
> > Suggestions? Comments?
> > 
> > --
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing 
list
> > To post a message email: RPG400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> > 
> >
> 
> -- 
> "Enter any 11-digit prime number to continue..."
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L)
>  mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To 
> subscribe, unsubscribe, or change list options, visit: 
> http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-
> L-request@xxxxxxxxxxxx Before posting, please take a moment to 
> review the archives at http://archive.midrange.com/rpg400-l.


--
Open WebMail Project (http://openwebmail.org)

-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.