Re: 2/29/2000 Problem?
Posted in 2000
Topics: Installation, Setup & Upgrades, Connectivity: ESQL/C, 4GL & Embedded SQL, Migration, Import/Export & Data Conversion, Platform-Specific Issues
I know that with SE 7.23 (and our environment setting) if you have a load file where 02/29/00 is present, it will attempt to load it as 02/29/1900 (which of course doesn't exist). Likewise, other 2000+ dates. If you load them as 02/29/2000 etc, it works correctly. For me, it was no big deal to expand to 4-digit dates in this script, so I didn't look further. I don't know if this has to do with DBCENTURY settings or what. At 10:30 AM 1/25/00 GMT, Victor Glass wrote: >This is a multi-part message in MIME format. >--------------73EDE42D556FD59BDA106ED4 >Content-Type: text/plain; charset=us-ascii >Content-Transfer-Encoding: 7bit > >I'm working with someone who is upgrading to: >4GL RDS 7.20.UE1 >SQL 7.20.UE1 >SE 7.24.UC8 >on Sun Ultra 5 running Solaris 2.7 > >They indicate: >after migration and upgrade of existing database, there is a 2-29-2000 >issue >that needs to be address. The Informix database will not accept a >record >load with a 2-29 Due Date or Send Date entry. > >Is there a Y2K problem with SE involving 2-29-2000? > >Vic > >--------------73EDE42D556FD59BDA106ED4 >Content-Type: text/x-vcard; charset=us-ascii; > name="vglass.vcf" >Content-Transfer-Encoding: 7bit >Content-Description: Card for Victor Glass >Content-Disposition: attachment; > filename="vglass.vcf" > >begin:vcard >n:Glass;Victor >tel;work:908.781.6541 >x-mozilla-html:FALSE >adr:;;;;;; >version:2.1 >email;internet:vglass@bellatlantic.com >fn:Vic Glass >end:vcard > >--------------73EDE42D556FD59BDA106ED4-- > > ========================================================================== Jim Miani ICANON Associates, Inc. Phone: 610-313-1850 x 121 Fax: 610-313-1848 NEWZware' is a product of ICANON Inc. - Visit our web site at http://www.icanon.com/ for more information on ICANON, the company, and its suite of products and services.