× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. August 2001

RE: Next SQL question

> 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 thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.