Guys, please stop crossposting with ADABAS and SAP DB.
If you have somethin ADABAS related, post it there. Is it SAP DB related, post it here. I think most SAP DB users are also reading the SuSE ADABAS NG. And ADABAS users should migrate to SAP DB immediately ;o) Sorry for the flame... Tilmann Starke SOFTWORK GmbH Help to prevent global warming by writing cool software. -----Urspr�ngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Im Auftrag von Georg Gesendet: Freitag, 3. Mai 2002 16:19 An: Schildberg, Steffen Cc: '[EMAIL PROTECTED]' Betreff: Re: error during repmcli / dataload / set command 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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
