Re: Embedded SQL with DSPF problem.

["Jake M" <jakeroc@xxxxxxxxx>]

Thanks, Buck. So, this part works just like .jsp front end being processed
by a bean..:-0). Got it. Thanks.

cheers,

Jake.

On 9/22/06, Buck <kc2hiz@xxxxxxxxx> wrote:
> >     c/exec sql
> >     c+ select ITMNBR, ITMDESCR into :myDS from
> >     c+ testing/item_pf where itmnbr=:itemnum
> >     c/end-exec
> >
> > if I remove the PR and PI, how will the SQL statement know 'itemnum'.?
>
> Look at the compiler listing.  There will be a section that describes
> the fields defined by the display file.  You would use the field name
> that corresponds to the item number in place of... where itmnbr=:itemnum
>
> (the name after the colon will be the same as the name in your display
> file)
>    --buck
> --
> 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.