Ok looks like I found a solution that might work, though it requires me to do alot more parsing. Adding the HEX keyword behind each CHAR field in the field list of DATAEXTRACT/DATALOAD should do the job, at least according to the docs.
----- Original Message ----- From: "Watz" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, August 16, 2003 10:14 PM Subject: LF in VARCHAR column confuses loadercli > Hi, > > I'm currently migrating a SAPDB 6.2 database to 7.4 by exporting the 6.2 catalog and > each table with xload in FORMATTED data files and importing it into a 7.4 database > with loadercli. I almost got it working now (including LONG columns) pretty > automated with a java tool creating 7.4 command files and fixing the data files > (long column offsets are expressed differently without "->" in 7.4) from the 6.2 > ones. > > I do have a slight problem and I hope theres a simple solution to it... > > For some reason some tables I want to export have hex 13 or hex 10 (CR/LF) in > VARCHAR fields. > Yes I know this is odd... > I have no idea how this happened (its a large DB and I'm not sure what the table is > used for). > This of course causes a line feed in the middle of a dataset if one would read the > file line by line and not by the rows size. > loadercli gets confused and complains about missing column data in such a line, so > it looks like loadercli loads a formatted data file line by line instead of reading > just the rowlength (which is fixed for FORMATTED files) regardless of any line feeds. > > I haven't tried to import in COMPRESSED mode, because there would be more > modifications necessary on the 6.2 compressed data files (format for FIXED fields is > different, 7.4 wants FIXED values in ", whereas 6.2 does not enclose them in " like > char fields). > > Do you have any quick solution for me ? > > Thanks, > Marco > > _______________________________________________ > 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
