× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



On 10/04/06, Stiju Easo <stiju.as400@xxxxxxxxx> wrote:

>  I want to update a PF through RPG program, which is created by SQL
> commands.
>  When i run DSPFFD to see field information , i didnt see any keyed field,
>
>  how can i upadte (precisely Write back a value into) that file,
>  I have done with chaining
>  but here there is no key to chain

Still using SQL you can create an index over your original table,
naming the fields or fields to be used as a key and also specifying
whether the keys are to be unique. The SQL index appears as a keyed
logical file which you can specify in your RPG program instead of the
physical.

--
Dave...


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.