exporting all tables present in the database

vgr12386 · #1 (**permalink**) 11-12-09, 05:19

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

vgr12386 · #2 (**permalink**) 11-12-09, 06:03

come on now some 1s gotta know something....

sathyaram_s · #3 (**permalink**) 11-12-09, 06:25

patience please ...

it is not fair to expect a response in <44 minutes for free

vgr12386 · #4 (**permalink**) 11-12-09, 06:35

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

dr_te_z · #5 (**permalink**) 11-12-09, 06:53

tell us more about the database. do you have LOB's BLOB's and things like that. If so: what do you expect?

vgr12386 · #6 (**permalink**) 11-12-09, 07:00

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

Internet Services

Web Development

Digital Marketing

Consumer Tech