But why does the last value work without the attribut list and the
"DEFAULT NULL" clause
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
