Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2008
    Posts
    3

    Unanswered: DB2 Export - row terminator?

    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-

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by kellypw
    Is there a row terminator I can specify in the DB2 export?
    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.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2008
    Posts
    3
    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

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Aug 2008
    Posts
    3
    doh! if it was a snake.... thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •