RE: ...along the embedded SQL path - Question and Comment

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

The source type must be SQLRPGLE not RPGLE.

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Douglas W. Palme
> Sent: Tuesday, July 12, 2005 9:53 AM
> To: RPG programming on the AS400 / iSeries
> Subject: ...along the embedded SQL path - Question and Comment
> 
> 
> First I would like to thank everyone for the helpful 
> suggestions, books, 
> url's, etc.  They were all appreciated and certainly have 
> helped answer some 
> questions.
> 
> however I am having one slight problem, I figured I would try 
> a simple count 
> test and see what happens, but whenever I enter the /Exec SQL 
> or /End-Exec I 
> keep getting a compiler directive not recognized, ignored error.
> 
> Here is how I coded the lines:
> 
> 0043.01 C/Exec SQL                                
> 0043.02 + SELECT COUNT(*) INTO :DEMO FROM IMPITN00
> 0043.03 C/End-Exec                                
> 0043.04 C                   EVAL      FLD01 = DEMO
> 0043.05 C                   EXFMT     MAIN        
> 0043.06 C                   EVAL      *INLR = *ON 
> 0043.07 C                   RETURN                
> 
> Any help would be appreciatd.
> 
> Douglas
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (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.
> 
>