RE: Problem defining sql fetch receiving DS

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Sorry my fault, my prototype was incorrect. As I wasn't even getting past the precompiler, I didn't notice.

 
> Hi all,
>
> Having a problem trying to declare a result set DS for my sql Fetch.
> The precompiler keeps giving 'variable yourResultSet not 
> defined or not usable'
>
>
> To narrow  things down, I changed the select to one field 
> only and hard-coded the receiver variable :
>
> d myproc          pi
> D hadhno          s              6  0   
>
>   EXEC SQL                             
>     FETCH NEXT FROM C1 INTO : hadhno; 
>
> This compiles, but if I do :
> D hadhno          s                   LIKE (my_refvar) 
>
> I get the same message from the compiler.
>
> I thought this was a bug that had been fixed. How am I going 
> to define a global ds that I can use as a receiver variable, 
> or a local ds based on a template that i can pass as a parameter?
>
> Thanks
> --
> 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.