I'm exporting data from a version 9 database, to import into another system (Oracle via sql loader) . Some of our varchar fields have hard returns making import fail. Is there a row terminator I can specify in the DB2 export? I'm currently using MODIFIED BY chardel'' coldel0x07 for delims -

Thanks-

No, but you can specify one for SQL*Loader - all you need to do is find a character that does not occur in your data and export it as the last column.

Fixed length records will be an even better alternative.

I must be missing something - hat's the SQLLoader row terminator? I did not see that in the Oracle documentation: SQL*Loader Control File Reference

SQL*Loader Concepts

doh! if it was a snake.... thanks!