Re: Question on repmcli

2003-12-16 Thread Albert Steckenborn
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

RE: Question on repmcli

2003-12-16 Thread Schildberg, Steffen
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

Re: Question on repmcli

2003-12-16 Thread Albert Steckenborn
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

RE: Question on repmcli

2003-12-16 Thread Schildberg, Steffen
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

RE: Question on repmcli

2003-12-16 Thread Schildberg, Steffen
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

AW: Question on repmcli

2003-12-16 Thread Christoph Weser
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

Re: Question on repmcli

2003-12-15 Thread Albert Steckenborn
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

Re: Question on repmcli

2003-12-15 Thread Jean-Michel OLTRA
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

Question on repmcli

2003-12-15 Thread Christoph Weser
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