Re: embedded sql session error in subfile

On Tue, 2005-07-26 at 21:06, Carel Teijgeler wrote:
> Douglas,
> 
> No PREPARE?

You only need the PREPARE if there are going to be parameter markers, so
this approach should be valid.

> And in what do you FETCH?
> 
> Besides, you should drink more coffee.

Definitely!

> On 26-7-05 at 13:52 Douglas W. Palme wrote:
> 
> >2. losing my mind or 3. had too much gaterade today.  In any event, I am 
> >using the following code to extract the records from the logical file:

You should specify the Physical File name, not the logical.  I'm not
sure if that will change your results, but it wouldn't hurt.

> >I am then using a fetch statement to extract the record, move them into 
> >variables and then write it to the subfile, however when I was in debug
> >mode 
> >and viewed the variables at it was moving them into the subfiles fields it 
> >wasn't passing any data.....so of course it errors on a blank record.

I assume the FETCH INTO matches the return types?  Actually, with static
SQL like this it should or I don't think it would compile.

What is the value of SQLSTT after you try the open?  You also may need
to look at the JobLog in debug and see if there are any messages there.

Joel Cochran
http://www.rpgnext.com