Re: Max date

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.