Re: Embeded SQL Question

Run interactive:
Select          Max(BbCCtT)    From VoCTrack     
    Where BBAssign =  '000000000000056450' and   
          BBCode   = 'STR'                       
    Group by BbAssign                            
    Having Count(*) > 1                          
MAX ( BBCCTT )    
    214,745       

Why does the precompiler not like this.

I can change it to a Select  INTO, but was under the impression that SET was the preferred method.

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
  
 






________________________________
From: "Michael_Schutte@xxxxxxxxxxxx" <Michael_Schutte@xxxxxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Sent: Mon, May 24, 2010 3:21:21 PM
Subject: 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.