Re: Max date

[Raul A Jager W <raul@xxxxxxxxxx>]

This looks like a very good solution, thank you.

On 09/21/2015 09:29 PM, CRPence wrote:
> On 21-Sep-2015 16:22 -0600, Raul A Jager W wrote:
> > I need to store a date value for a "does not expire" document. I
> > think the easiest will be to insert 9999/12/31 which when compared
> > with the actual date will result Ok.
> > Is there a symbolic name for the maximum date? something like
> > infinite for numbers?
> >
> > I will like to write something like:
> >
> >    exec sql insert into table(exp_date) values(?????)
> >
> > where ????? will be replaced by an appropriate name.
>
>   Perhaps use the *HIVAL of RPG to define the value:
>
>     D maxDate         S               D   inz(*HIVAL) datfmt(*iso)
>
>         exec sql insert into table(exp_date) values(:maxDate)
>
>   The declarative could be part of an include that defines that and
> perhaps some other effective constants.


-- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- 
            -- Verificado por Anti-Virus Corporativo Symantec --