Thank you very much again,
I will try it.
But then, unfortunately I've to enhance my import script a little bit.
Currently I have only a "for each loop" without the attributlist against
a list of tables which has to be exported/imported.
The only way to implement this now is to go through the metadata of the
tables and include the attribute list that way
during the import, isn't it?
Bye
Georg
Schildberg, Steffen wrote:
>Hi Georg,
>there is a little mistake in the docs describing the null value
>specification in load commands with the 'SET NULL' command.
>It is not enough to specify the NULL specifier with 'SET NULL'
>command but you must also mark all columns allowing NULLs in the
>data with DEFAULT NULL (I'm sure this feature exists in ADABAS,too).
>Furthermore there is a problem with
>empty fields in the data. Even empty fields must be included in
>delimiters (or you run it without delimiters at al if xload allows
>it during extracting the data).
>So your command file could look this way
>
>SET NULL '?'
>/
>DATALOAD TABLE &1
>"FIELD1" 1
>"FIELD2" 2
>"FIELD3" 3
>"FIELD4" 4
>"FIELD5" 5
>"FIELD6" 6
>"FIELD7" 7
>"FIELD8" 8 DEFAULT NULL
>"FIELD9" 9 DEFAULT NULL
>"FIELD10" 10
>"FIELD11" 11
>"FIELD12" 12 DEFAULT NULL
>INFILE 'userdata.dat' separator '|'
>
>Your data should look like this
>"1"|"A"|"A"|"1"|"111"|"111"|"111"|"?"|"?"|"FALSE"|"XXX"|"?"
>
>I would suggest to work with a question mark as null spec during
>extract and load.
>
>I know the handling of empty fields is kind of inconvinient. I
>thought I solved this problem already in an earlier version. But
>introducing a new pattern search seems to have it brought back
>on the table. I'll work on it.
>Let me know if I can help further.
>Regards,
> Steffen
>
--
Georg Thom�
Diplom Informatiker(FH)
Process Informatics
IEE Luxembourg
zone industrielle
L-6468 Echternach
phone 00352/728989-6810
fax 00352/728989-6109
email [EMAIL PROTECTED]
web www.iee.lu
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
