Hi Arne, thx for the comments. I've added some more to make repmcli even look better ;-)
Arne Gehlhaar wrote: > > 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? > This is a matter of the point of view. What if you have 54 columns which are all set to not allow NULL and all have anywhere a NULL representation string as data. I know it's a somehow artificial/unreal situation. But anyway. Because it was now mentioned several times here in the list we'll think again about the behavior of RepMan on NULLs. > 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' > We'll put it on the wish list. > 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. > Yep, a known problem. Somehow inconsistent. > Also ADABAS writes integers as '1 234 567' which repmcli cannot read. > I'd say that's not true. You can adapt the behavior of RepMan regarding numbers with the DECIMAL specification to the file like this (see chapter number_spec in the docs) DATALOAD TABLE <table name> <column name> <pos> INFILE <file name> DECIMAL '/ /,/' This command should load a number as you specified it above. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
