RE: AW: embedded sql session error in subfile

Douglas,

Repeat after me....

"I must check SQLSTT after each embedded SQL statement."


Now, add the code to check SQLSTT and let us know what the error is.

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: Wednesday, July 27, 2005 9:10 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: AW: embedded sql session error in subfile
> 
> 
> Bruce Guetzkow wrote: 
> 
> "You need to specify the same fields for Order By and Group 
> By...SQL is VERY 
> fussy about that."
> 
> What is the difference between running the sql statement in 
> an rpgle versus 
> the interactive sql utility (strsql)?
> 
> I used the exact same select statement in the interactive as 
> I had in the 
> program and it ran ok....
> 
> I know its going to be something very simple that I am screwing up....
> 
> 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.
> 
>