This is probably the same problem as before. I had not specified any null_condition on the columns, so for char() columns, the '?'-character was inserted. Of course this did not succeed for numerical columns, because '?' is not a valid number, just as the error message told me. So this 'bug' isn't one.For integer and float values, repmcli does not recognize null values. For every column that is either integer of float I have to use the null_condition. Is this expected behaviour?
Nope, it isn't. Some error message avalailble?
It's just that I had expected that repmcli would automatically recognize the '?' as NULL which is what I specified as the default null value to be. So now my DATALOAD command which has 54 columns has to have 54 DEFAULT NULL clauses - not realy a problem just a bit clumsy. Wouldn't it be easier, if the defined null character is always taken as DEFAULT NULL unless otherwise specified?
Another thing that I would find helpfull is IF-conditions for assigments on column level not only involving NULL. Something like
DATALOAD TABLE test
primary_key 1
some_column 2
foreign_key 3 17 IF POS 3 > 100 (same as null_condition page 60)
or
foreign_key 3 IF POS 3 > 100 SET 17 (same as null_assign page 59)
INFILE 'data.lst'
Anyway, I finally managed to load the data by dropping some constraints and reformatting my infile. For some reason ADABAS's xload does not write the delimiter around numerical values on DATAEXTRACT. Also ADABAS writes integers as '1 234 567' which repmcli cannot read. Nothing that a couple of sed scripts can't fix.
Thanks anyway for the help,
Arne
--
Institute of Shipping Economics and Logistics http://www.isl.org/
Arne Gehlhaar mailto:[EMAIL PROTECTED]
Universitaetsallee GW1 Block A phone:+49.421.22096.49
D-28359 Bremen, Germany fax:+49.421.22096.55
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
