Error "1206 - Invalid day in date " while importing 
Author Message
 Error "1206 - Invalid day in date " while importing

Hi Rajesh.

Probably 29/02/00 look like 29/02/1900.
[ifmx28 ~] cal 2 1900
   February 1900
 S  M Tu  W Th  F  S
             1  2  3
 4  5  6  7  8  9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28

So I think change the date DD/MM/YY to DD/MM/YYYY.

Or upgrade Y2K-compliant(probably 5.10).


Quote:
>Hi,

>We are running informix ver 5 on sco opensever 5. I am importing a database
>on newly created instance.
>When I run the dbimport command, it interrupts with following error. When i
>checked unl file, it gives the error for a record which has 29/02/00 value.
>If I remove this record then it work smoothly, but there are many unl files
>which are having records of this date. It is not possible to delete these
>records everytime.

>*** put loadcur
>1206 - Invalid day in date

>Kindly tell me is there any date environment parameter to avoid it.

>Regards
>Rajesh Kokane

--
Tsutomu Ogiwara

INFORMIX PROFESSIONAL SERVICES
DATABASE BUSINESS DEPT.
ITOCHU TECHNO-SCIENCE Corporation
KURITA-KUDAN BLDG., 1-11-15, FUJIMI,
CHIYODA-KU TOKYO,102-0074 JAPAN



Sun, 13 Jun 2004 15:34:29 GMT
 Error "1206 - Invalid day in date " while importing

Hi Rajesh.

How about the following?

sed 's/\/00/\/2000/' file > file1

e.g)
[ifmx28 ~] cat d
1|2|29/02/00|
[ifmx28 ~] sed 's/\/00/\/2000/' d
1|2|29/02/2000|

Regards.


Quote:

>I have tried database import by setting value of dbdate as DMY4/ as well as
>DMY2/ in the .profile file but still it is giving same error. Upgradation of
>informix ver. is not possible.

>Kindly tell me do i need to set any other parameter to overcome the problem
>?

>Thanks & Regards

>Rajesh Kokane

>> ----------

>> Sent:  Wednesday, December 26, 2001 1:04 PM
>> To:    Kokane Rajesh, IBM
>> Cc:    'Informix'
>> Subject:       Re: Error "1206 - Invalid day in date " while importing
>> database

>> Hi Rajesh.

>> Probably 29/02/00 look like 29/02/1900.
>> [ifmx28 ~] cal 2 1900
>>    February 1900
>>  S  M Tu  W Th  F  S
>>              1  2  3
>>  4  5  6  7  8  9 10
>> 11 12 13 14 15 16 17
>> 18 19 20 21 22 23 24
>> 25 26 27 28

>> So I think change the date DD/MM/YY to DD/MM/YYYY.

>> Or upgrade Y2K-compliant(probably 5.10).


>> >Hi,

>> >We are running informix ver 5 on sco opensever 5. I am importing a
>> database
>> >on newly created instance.
>> >When I run the dbimport command, it interrupts with following error. When
>> i
>> >checked unl file, it gives the error for a record which has 29/02/00
>> value.
>> >If I remove this record then it work smoothly, but there are many unl
>> files
>> >which are having records of this date. It is not possible to delete these
>> >records everytime.

>> >*** put loadcur
>> >1206 - Invalid day in date

>> >Kindly tell me is there any date environment parameter to avoid it.

>> >Regards
>> >Rajesh Kokane

>> --
>> Tsutomu Ogiwara

>> INFORMIX PROFESSIONAL SERVICES
>> DATABASE BUSINESS DEPT.
>> ITOCHU TECHNO-SCIENCE Corporation
>> KURITA-KUDAN BLDG., 1-11-15, FUJIMI,
>> CHIYODA-KU TOKYO,102-0074 JAPAN


--
Tsutomu Ogiwara

INFORMIX PROFESSIONAL SERVICES
DATABASE BUSINESS DEPT.
ITOCHU TECHNO-SCIENCE Corporation
KURITA-KUDAN BLDG., 1-11-15, FUJIMI,
CHIYODA-KU TOKYO,102-0074 JAPAN



Mon, 14 Jun 2004 14:18:34 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Error "1206 - Invalid day in date " while importing database

2. Invalid DATE type statement "#"

3. Invalid date "02/29/2100"

4. trigger error - Invalid Object "Inserted"

5. "Invalid Cursor Error"

6. Snapshot replication gives "Invalid Descriptor Error"

7. "Invalid Attribute/ Option Identifier" Error

8. error: "invalid column name"

9. Error #208 "Invalid Object Name"

10. "Handle is invalid" errors

11. SQL 7.0 error "Invalid Cursor State"

12. ERROR 3001 - "Invalid Argument"


 
Powered by phpBB® Forum Software