Re: Embeded SQL Question

Run the select interactively. What kind of error (or results) do you get?
Is it what you expect?

I'm assuming that it's because you will get a result set of more than one
record. Add "fetch first 1 rows only" after your having clause.



--

Michael Schutte
Admin Professional



Announcing Bob Evans Bob-B-Q® Road Trip! For a limited time, America's best
Bob-B-Q® tastes are all at Bob Evans! For more information, visit
www.bobevans.com/menu/seasonal.aspx





Jeff Young
<cooljeff913@yaho
o.com> To
Sent by: rpg400-l@xxxxxxxxxxxx
rpg400-l-bounces@ cc
midrange.com
Subject
Embeded SQL Question
05/24/2010 03:11
PM


Please respond to
RPG programming
on the IBM i /
System i
<rpg400-l@midrang
e.com>






Given the following SQL Statement, why is the precompiler complaining about
the MAX keyword?

Exec SQL
  Set :Last_Start =
    Select Max(BbCCtT) From VoCTrack
         Where BBAssign = :Assignment and
               BBCode   = 'STR'
         Group by BbAssign
         Having Count(*) > 1;

Thanks,

Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions
V5R2
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical
Solutions Implementer V5R3
--
This is the RPG programming on the IBM i / System i (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.