× 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.



This reminds me of a pending question I've had that might
help. I've checked the manual, but can someone refresh my
mind on the SQL function that takes one value from a list of
two, where one is a database value, and the other is a value
to select in case the database value is null? (Or something
like that?)

- Alan






----- Original Message -----
From: "Joel Cochran" <jrc@xxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries"
<rpg400-l@xxxxxxxxxxxx>
Sent: Friday, October 10, 2003 2:56 PM
Subject: Re: SQL loval date/timestamp


| Hi guys,
|
| Sorry I haven't gotten back to this yet, I've been out of
town since
| Tuesday.
|
| I have some traditional, DDS based, PFs with Date fields
that may or may
| not get populated at the initial write.  If they do not
get populated,
| then their default value is '0001-01-01' as one might
expect.  However,
| what I've run into is that in an SQLRPGLE program, when I
try to fetch a
| record that has one of these fields in it, I get an SQL
error saying "A
| Date or Timestamp is Invalid" and the record is NOT
fetched into the
| DS.  If I put a date value in the record then it processes
as desired.
|
| I remember hearing this from other people, and I remember
reading that
| the lowest Date SQLRPGLE will process is like '1940-01-01'
or something
| like that, but I can't seem to find the reference again.
That way, when
| I write a record I can insert a date that SQL will
process, and if I
| know what it is I can programmatically ignore it.
|
| Thanks,
|
| Joel
| http://www.rpgnext.com
|
|
| On Tue, 2003-10-07 at 18:02, Buck wrote:
| > > However, when we display the column that
| > >does have a null value, the display
| > >shows '0001-01-01'.
| >
| > That depends on how you display the column.  Some IBM
utilities will show
| > you *LOVAL out of 'courtesy' I suppose.  In earlier
releases I used to be
| > able to set a field value, update the record, set NULL,
update the record,
| > CHAIN to a new record, CHAIN to the first record and see
the original value,
| > despite it being NULL.
| >
| > The moral is that one can't depend on the value of a
field when it is NULL.
| >   --buck
| >
| >
| >
| > _______________________________________________
| > This is the RPG programming on the AS400 / 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.
|
| _______________________________________________
| This is the RPG programming on the AS400 / 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.
|


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.