dbimport error ...
Hello,
When I do dbimport , I get the error :-
create table "rismgr".powerfail_dtl
(
powerfail_sdate date,
powerfail_stime datetime hour to minute,
powerfail_edate date,
powerfail_etime datetime hour to minute
);
*** put loadcur
1205 - Invalid month in date
:q!
I think its some "env" variable to be set. I tried DBDATE=MDY4 but it didnt
work.
Or is it actually "datetime hour to minute" thats causing the error ?
Please post ur replies ...
Thx
Hi,
either your data is incorrect (unload-file for powerfail_dtl - first or third
column)
or has different date format.
Did you do the dbexport, too? Different environments between dbexport and
dbimport?
Regards,
Andreas Kutsche
>
-------------------------------------------
SPAR Oesterreichische Warenhandels-AG
Hauptzentrale
Europastrasse 3
A - 5015 Salzburg
Tel: +43 662 4470 24223
Mobile: +43 664 6259575
E-Mail: Andreas.KUTSCHE@spar.at
Internet: http://www.spar.at
-------------------------------------------
-----Urspr|ngliche Nachricht-----
> Von: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]Im
> Auftrag von SANTOSH NIKUMBH
> Gesendet: Dienstag, 04. Oktober 2005 09:23
> An: ids@iiug.org
> Betreff: dbimport error ... [5798]
>
>
> Hello,
>
> When I do dbimport , I get the error :-
>
>
> create table "rismgr".powerfail_dtl
> (
> powerfail_sdate date,
> powerfail_stime datetime hour to minute,
> powerfail_edate date,
> powerfail_etime datetime hour to minute
> );
> *** put loadcur
> 1205 - Invalid month in date
> :q!
>
>
>
> I think its some "env" variable to be set. I tried
> DBDATE=MDY4 but it didnt work.>
> Or is it actually "datetime hour to minute" thats causing the error ?
>
> Please post ur replies ...
>
> Thx
Check the .unl file for the date format and set
DBDATE accordingly.
-----Original Message-----
From: SANTOSH NIKUMBH [mailto:sagarthanawala@yahoo.com]
Sent: 04 October 2005 08:23
To: ids@iiug.org
Subject: dbimport error ... [5798]
Hello,
When I do dbimport , I get the error :-
create table "rismgr".powerfail_dtl
(
powerfail_sdate date,
powerfail_stime datetime hour to minute,
powerfail_edate date,
powerfail_etime datetime hour to minute
);
*** put loadcur
1205 - Invalid month in date
:q!
I think its some "env" variable to be set. I tried DBDATE=MDY4 but it
didnt work.
Or is it actually "datetime hour to minute" thats causing the error ?
Please post ur replies ...
Thx
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System before entering the GFM Network. If you have any
queries please contact Systems Administration or IT.
________________________________________________________________________
______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________
You need also the field separator in your variable DBDATE=MDY4/ corresponds to 10/04/2005 and DBDATE=MDY- corresponds to 10-04-2005 *****DISCLAIMER***** Dit bericht en alle bijhorende zijn uitsluitend bestemd voor de geadresseerde en vertrouwelijk. Indien dit bericht niet voor U bestemd is, gelieve dit dan te vernietigen en de verzender te verwittigen. Openbaring, vermenigvuldiging, verspreiding en verstrekking aan derden is niet toegestaan, tenzij anders vermeld. Aangezien internet de integriteit van dit bericht niet kan verzekeren, kan de Dienst Vreemdelingenzaken niet verantwoordelijk gesteld worden indien dit bericht gewijzigd is. Bezoek onze website: http://www.dofi.fgov.be ---------------------------------------- *****DISCLAIMER***** Ce message et toutes les pieces jointes sont etablis a l'intention exclusive de ses destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le detruire et d'en avertir l'expediteur. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, l'Office des Etrangers decline toute responsabilite au titre de ce message, dans l'hypothese ou il aurait ete modifie. Visitez notre site web: http://www.dofi.fgov.be
SANTOSH
NIKUMBH wrote:
>Hello,
>
> When I do dbimport , I get the error :-
>
>
>create table "rismgr".powerfail_dtl
> (
> powerfail_sdate date,
> powerfail_stime datetime hour to minute,
> powerfail_edate date,
> powerfail_etime datetime hour to minute
> );
>*** put loadcur
>1205 - Invalid month in date
>:q!
>
>
>
>I think its some "env" variable to be set. I tried DBDATE=MDY4 but it didnt
work.
>
>Or is it actually "datetime hour to minute" thats causing the error ?
>
>Please post ur replies ...
>
>Thx
>
>
>
>
>
Hi
On IDS have folowing variables for NLS:
SERVER_LOCALE=
DB_LOCALE=
CLIENT_LOCALE=
DBDATE=
DBLANG=
Dimitar Bachvarov
[demime 1.01d removed an attachment of type text/x-vcard which had a name of
dimitar.bachvarov.vcf]