Re: Embeded SQL Question

[Alan Campin <alan0307d@xxxxxxxxx>]

Group By. You are selecting only one assigment but attempting to group by
it.

On Mon, May 24, 2010 at 1:11 PM, Jeff Young <cooljeff913@xxxxxxxxx> wrote:

> 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.