big big trouble with dbimport and sbspace and date format
hey,
i'm using universal server 9.14 on solaris 2.5.1
because i don't know how to resize a metadata space.l neet to migrate some
app
to a second sbspace before dropping the first one in order to recreate it
with a bigger
metadata.
during the migrating procedure, i got errors:
i've used dbexport mydatabase -c -ss -o .
then i edit the mydatabase.exp/mydatabase.sql file so that it can reference
the
second sbspace.
i launch the command dbimport mynewdatabasename -d -d dbspacename -l
buffered -i .
Guess what i get?
reate table "dzana".licence_participan
(
numero_licence_par serial not null constraint "dzana".n455_1614,
numero_participant integer not null constraint "dzana".n371_1325,
date_deb_validite datetime year to second,
date_fin_validite datetime year to second,
contrat_signe_part char(1)
default 'N',
numero_dossier_lic integer,
numero_societe_lic integer,
numero_contrat_lic integer,
id_user_creation char(5),
date_creation_info datetime year to second
default current year to second,
id_user_modif_info char(5),
date_modif_informa datetime year to second
default current year to second,
timestamp date
default today
) extent size 16 next size 16 lock mode page;
*** put loadcur
1204 - Invalid year in date
i look at my unl file and i call the informix support france.
here is the sample
173|263|1998-10-21 00:00:00|1999-12-31 23:59:59|O|1|1|1||1998-10-21
18:07:45||1998-10-21 18:07:45|10/21/1
998|
2|4|1998-08-25 00:00:00|1999-01-24 23:59:59|N|||||1998-04-04
00:00:00||1998-04-04 00:00:00|08/24/1998|
3|5|1998-08-25 00:00:00|1999-01-24 23:59:59|N|||||1998-04-04
00:00:00||1998-04-04 00:00:00|08/24/1998|
4|8|1998-08-25 00:00:00|1999-01-24 23:59:59|N|||||1998-04-04
00:00:00||1998-04-04 00:00:00|08/24/1998|
5|9|1998-08-25 00:00:00|1999-01-24 23:59:59|N|||||1998-04-04
00:00:00||1998-04-04 00:00:00|08/24/1998|
6|12|1998-08-25 00:00:00|1999-01-24 23:59:59|N|||||1998-04-04 00:00:00||1998
-04-04 00:00:00|08/24/1998|
they told me to set DBDATE with Y4MD/
then i get another error about date format
reate table "dzana".type_metier_produi
(
code_type_met_prod serial not null constraint "dzana".n344_1198,
description varchar(60) not null constraint "dzana".n344_1199,
id_user_creation char(5),
date_creation_info datetime year to second
default current year to second,
id_user_modif_info char(5),
date_modif_informa datetime year to second
default current year to second,
timestamp date
default today,
element_desactive char(1)
default 'N' not null constraint "dzana".n344_1200,
primary key (code_type_met_prod) constraint "dzana".pk_type_metier_pro
) extent size 16 next size 16 lock mode page;
*** put loadcur
1218 - String to date conversion error
i check the unl file but i found anything of special
here is the entire data:
1|Author||1998-08-14 16:19:20||1998-08-14 16:19:20|08/14/1998|N|
2|Director||1998-08-14 16:19:28||1998-08-14 16:19:28|08/14/1998|N|
3|Information||1998-08-14 16:19:38||1998-08-14 16:19:38|08/14/1998|N|
4|Credits||1998-08-14 16:19:49||1998-08-14 16:19:49|08/14/1998|N|
5|Producer||1998-08-14 16:19:58||1998-08-14 16:19:58|08/14/1998|N|
So what's wrong with my files.thanks for any help.
georges.