|
midrange.com
> My embedded sql/rpg program works, sorta, it works only if my date fields
> have real values in them, and not the default 0001-01-01 values...
>
> what should I do? I keep getting a 183 error, which is a
> timestamp problem,
> but If I force in a date, it does work... But I was hoping to
> use *loval to
> inform me that my date field is unchanged...
>
> thanks, tim
>
Check the defaults for CRTSQLRPGI for DATFMT, DATSEP, TIMFMT, and TIMSEP
I use DATFMT(*ISO), DATSEP('-'), TIMFMT(*ISO), and TIMSEP('.')
I think the SQL precomiler ignores the DAT* and TIM* keywords in the source
member.
Phil
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
