Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    80

    Unanswered: unload to a file

    Hi - How do I unload data from a table to a pipeline separated file???

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Use export command with delimited format. You can choose the delimeter. See the Command Reference Manual.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2005
    Posts
    80
    Would it be possible to copy a table(along with the data) in a new schema? I tried the MQT but that didnt help. it showed me that I cant modify the existing table. any suggestions???

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    hi,
    create table with new schema and then "insert into newtable select * from old_table"
    Regards

Posting Permissions

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