Re: Field Names

[B Stone <bvstone@xxxxxxxxx>]

Dynamic SQL would probably be the best way.  Build the select statement
using the name of the field to select data from.


Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #10 <https://www.bvstools.com/mailtool.html>: Resend
Emails - When emails are sent using MAILTOOL Plus or another addon, those
emails are logged and you have the ability to resend them one by one, or as
a batch (ie, all unsent emails at once).

On Fri, Jun 7, 2019 at 9:33 AM Buddy McClean <Buddy.McClean@xxxxxxxxxxxx>
wrote:

> Good Day,
>
> Perhaps a silly question and an obvious answer, but I seem to have a bit
> of fog about it.
>
> What is the best way to translate a field that contains the name of
> another field to be able to reference the second field. Other than do a
> bunch of compares.
>
> DCL-S Field1 char(8) INZ('FIELD2')
>
> To be able to use FIELD2 in calculations. FIELD2 is an actual field in a
> record, but I only have the literal name of the field.
>
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com