Hi Steffen,
it's the same with loadercli in MAXDB 7.5.00.5.
With the SAPDB/MYSQL policy at the moment there will be only a update at
MAXDB. :-(
Regards
Albert
Schildberg, Steffen schrieb:
Hi Albert,
Albert Steckenborn [mailto:[EMAIL PROTECTED]
i 've had the same probs with my tables. For all
Hi Albert,
Albert Steckenborn [mailto:[EMAIL PROTECTED]
>
> i 've had the same probs with my tables. For all INT/FIXED values if
> have to define a "if" clause.
> The default for NULL VALUES is completely ignored for this datatypes.
>
The problem (bug) is found and fixed at the development syst
i 've had the same probs with my tables. For all INT/FIXED values if
have to define a "if" clause.
The default for NULL VALUES is completely ignored for this datatypes.
Schildberg, Steffen schrieb:
Hi Christoph,
Christoph Weser [mailto:[EMAIL PROTECTED] wrote:
I'm using the following statement
Hi Christoph,
Christoph Weser [mailto:[EMAIL PROTECTED] wrote:
>
> > Albert Steckenborn [mailto:[EMAIL PROTECTED] wrote:
> > i think this will work,
> >
> > DATALOAD TABLE s_entitytype
> > ETTID 1 NULL IF POS 1 =''
> > INFILE 'dat\entitytype.dat'
> > DELIMITER ''
> > NULL
Hi Christoph,
Christoph Weser [mailto:[EMAIL PROTECTED] wrote:
>
> I'm using the following statement to load data into a table using the
> repmcli:
>
> DATALOAD TABLE s_entitytype
> ETTID 1 DEFAULT NULL
> INFILE 'dat\entitytype.dat'
> DELIMITER ''
> NULL ''
>
[sn
AIL PROTECTED]
Betreff: Re: Question on repmcli
Hi,
i think this will work,
DATALOAD TABLE s_entitytype
ETTID 1 NULL IF POS 1 =''
INFILE 'dat\entitytype.dat'
DELIMITER ''
NULL ''
but make shure that the value of the
Hi,
i think this will work,
DATALOAD TABLE s_entitytype
ETTID 1 NULL IF POS 1 =''
INFILE 'dat\entitytype.dat'
DELIMITER ''
NULL ''
but make shure that the value of the field is '' and not ' '.
rgds.
Albert
Jean-Michel OLTRA schrieb:
Le lundi 15 décembre
Le lundi 15 décembre 2003, Christoph Weser a écrit...
bonjour,
> DATALOAD TABLE s_entitytype
> ETTID 1 DEFAULT NULL
> INFILE 'dat\entitytype.dat'
> DELIMITER ''
> NULL ''
> Missing data for specified column ETTID"
> Is this a bug or a feature? If it is a
Hello everyone.
I'm using the following statement to load data into a table using the
repmcli:
DATALOAD TABLE s_entitytype
ETTID 1 DEFAULT NULL
INFILE 'dat\entitytype.dat'
DELIMITER ''
NULL ''
The table is:
create table s_entitytype (
ETTID FIXED(3