RE: Date problem

Rob
"However, a workaround, until remediation of the file can be completed, is
to make a logical file, or SQL view, that treats the yymmdd decimal field
as a true date field."

Could you post an example of this using the logical file approach

Michael

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, June 14, 2006 7:42 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: Date problem

Part of the problem is that you "perceive" that you need to take this date
field and change it back to a decimal yymmdd because that is what the key
to the file is and you want to do a setll.

If you can absolutely guarantee that no date in that file is from the last
century then the techniques presented by others should work.  However, a
workaround, until remediation of the file can be completed, is to make a
logical file, or SQL view, that treats the yymmdd decimal field as a true
date field.  True, computed on the fly fields are not the best performers,
but it will work.  Sounds like fun to make that file but I've got a
project that's hot.

First of all whoever did not remediate that file as part of the Y2K
project needs to be horse dragged through a cactus field.  And if they
created the file after that time they need to quit and become a greeter at
Walmart.

Funny thing is, if the file remains yymmdd and you can guarantee that it
will always remain this century, then you might be better off doing the
setll on the number.  Because converting a yymmdd to a date field has
funny rules about the year 2040.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
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 message contains information from Certegy, Inc which may be confidential 
and privileged.  If you are not an intended recipient, please refrain from any 
disclosure, copying, distribution or use of this information and note that such 
actions are prohibited.  If you have received this transmission in error, 
please notify by e:mail postmaster@xxxxxxxxxxxx
==============================================================================