Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2011
    Posts
    29

    Unanswered: DB2 V9.1 (AIX 5.3) Difference between export and pipe

    If I have would like to load from one table to another (I know we can use cursor load's put the point of my question is to understand the difference and the reason of using a pipe or an export to flat file).

    Why would one rather export to a pipe and then load to the target table as oppose to exporting the source table to a flat file and then loading to the target table?

    Thanks,

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by sanchez786 View Post

    Why would one rather export to a pipe and then load to the target table as oppose to exporting the source table to a flat file and then loading to the target table?
    Disk space and extra disk I/O come to mind.
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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