Re: MAPVAL issues

[John McKee <jmmckee@xxxxxxxxxxxxxx>]

I have no experience with that keyword.  But, from creating numerous
Crystal Reports, I am a bit suspicous of your date.  Specifically, the
century.  Might it be a requirement that the value is 19 or 20?  I know
that SQL 2000 soes not allow a century less than 18.  Haven't worked with
SQL 2000 (Windows thing) in four years, but lowest date allowed, I think,
was 01/01/1800.  I am guessing that rather than throwing an error, it just
got skipped.  Which also seems odd.

John McKee


On Wed, Jul 30, 2014 at 12:29 PM, Mark Murphy/STAR BASE Consulting Inc. <
mmurphy@xxxxxxxxxxxxxxx> wrote:

> Does anyone use the MAPVAL keyword? I am having the following issue,
>
>
> My date field is defined like so:
>      A            RPTDT           L  I  5 29DATFMT(*USA)
>      A                                      MAPVAL(('01/01/0001' *BLANK))
>
> I am reading into a data structure defined like this:
>          dcl-ds dsprec likerec(display: *all);
>
> But when I read the record (using EXFMT), a blank keyed on the screen is
> input as a blank which causes invalid format error when the field is used.
>
> What am I doing wrong?
>
> Mark Murphy
> STAR BASE Consulting, Inc.
> mmurphy@xxxxxxxxxxxxxxx
> --
> This is the RPG programming on the IBM i (AS/400 and 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.