RE: Embeded SQL Question

Jeff,



What about :



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




“If you think education is expensive, try ignorance"
(Derek Bok, pres. of Harvard Univ. 1971-1990)

Date: Mon, 24 May 2010 12:11:49 -0700
From: cooljeff913@xxxxxxxxx
Subject: Embeded SQL Question
To: rpg400-l@xxxxxxxxxxxx

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.