Re: Need help with using a field's contents.

[B Stone <bvstone@xxxxxxxxx>]

Building a dynamic SQL statement would work I bet.


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 Thu, Nov 29, 2018 at 10:25 AM Cyndi Bradberry <CyndiB@xxxxxxxx> wrote:

> We are working on a project that combines C# web development and RPGLE
> using the same data.  Our C# group has created the table below to identify
> which date field amongst all the different date fields is to be used in a
> comparison with another file. We are to chain to this file with the
> CDDateId and use the CDYYFIELD to select the date from the master file.
>
> Our problem is in RPGLE, I now have the value MAPRYY in the field
> CDYYFIELD. How do I then retrieve the value in the field MAPRYY ?
>
>
> CDDATEID    CDDATENAME                     CDTABLE
> CDKEYFIELD                     CDYYFIELD
>           1  N/A
>           2  Application Date               MASTER
>  MAEKEY                         MAAPYY
>           3  Purchase Date                  MASTER
>  MAEKEY                         MAPRYY
>           4  Lock Expiration Date           MASTER
>  MAEKEY                         MAEXYY
>           5  Lock Date                      MASTERHST
> ELOAN                          LOCKYY
>           6  Reservation Date               LCDATA1
> ADEKEY                         ADLOCKDT
>
> My thoughts originally is to build a simple service program that would use
> nested If statements to retrieve the actual date and pass it back to the
> calling program. This would allow us to only have to update one program if
> they add more rows to the above table.
>
> If anyone has another idea, we would be happy to learn. We have only RPGLE
> on the system.
>
> Not sure if I explained this very well, we have been looking for ideas for
> a few days, but haven't found anything.
>
> Thanks,
>
> Cyndi B.
> Boise, Idaho
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-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