Link to home
Start Free TrialLog in
Avatar of Amit Samaria
Amit Samaria

asked on

Error "INTO clause missing from embedded statement. " please help i dont know why its coming.

please help for this

    Read hpol01;                                          
    DOW NOT %EOF(HPOL01);                                  
   exec sql SELECT PPROD,PVEND,max(PEDTE) AS PDTE          
   FROM hpo where pwhs='CP'  GROUP BY PPROD , PVEND;      
    PPPROD= PPROD;                                        
    PPVEND= PVEND;                                        
    PPEDTE=pdte;                                          
    Read HPoL01;                                          
    write(e) PURHL1;                                      
    EndDo;                                                
                                                           
     *InLR = *On ;
SOLUTION
Avatar of Nitin Sontakke
Nitin Sontakke
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Amit Samaria
Amit Samaria

ASKER

thanks but its not giving proper result
Just as expected!
hi,
got the solution thanks for reply
If possible, post it for record! Might as well have look.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
OP said a solution was found yet chose not to post it. daveslash gave correct answer(s) based on OP info. Nitin gave a mostly correct general form, though it wasn't specific to the programming language. tliotta explanatory background to say why the error happened.