Re: Embedded SQL with DSPF problem.

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.