Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2009
    Posts
    6

    Unanswered: exporting all tables present in the database

    Hi,
    i've nvr been good on the db side
    I jst wanted to know the easiest way to export all tables present in my database to <Tablename>.txt(or csv).
    i tried this:

    db2 " export to tablename.txt/csv of del select * from tablename"

    The main problem with this was that it threw up a bunch of errors stating that particular coulumns have been truncated ..... in short it has a 254 byte capacity.

    im not quiet sure about how to convert a .ixf file to a text or csv file.
    Do let me kow if you have come across stuff like this..
    Thanx

  2. #2
    Join Date
    Aug 2009
    Posts
    6
    come on now some 1s gotta know something....

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    patience please ...

    it is not fair to expect a response in <44 minutes for free
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Aug 2009
    Posts
    6

    it's like reaching out to d stars n landing on d moon

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    tell us more about the database. do you have LOB's BLOB's and things like that. If so: what do you expect?

  6. #6
    Join Date
    Aug 2009
    Posts
    6
    naaa nothing special..... i installed db2 v9 sometime back...
    heres' a snapshot of what it looks like when i log in from my cygwin prompt....

    Code:
       Database Connection Information
    
     Database server        = DB2/AIX64 9.1.2
    There are around 20 tables. I just wanted to back them up to a text or csv file so that i could take a look at it on excel after the processing is done.
    The ixf format doesn't let me do that and when i export it using the "del" thing, truncates most of my columns
    Last edited by vgr12386; 11-12-09 at 08:16.

Posting Permissions

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