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