469,271 Members | 1,052 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

DB2 export to flat file

1
Hello

I'm very new to using DB2, and would like to know about exporting the contents of a table to a flat file. For example, I have the following character string in a text field

Craig Sweeney 99 Letsby Avenue Scotland UK.

I would like to be able to extract the contents of this field to a txt file so that it was in the following format

Craig Sweeney
99 Letsby Avenue
Scotland
UK

I'm using the following command to do the export

export to file of del
select * from ADDRESS

But am unsure as to how to format the export .

Any Ideas...?

Regards
Craig
May 18 '07 #1
1 25014
this is the sytax for export

EXPORT to <path> of <o/p file format> [ MESSAGES <path> ]
<'select statement'>


example:

EXPORT TO file.del of DEL ' select * from emp'

db2 supports .del,ixf,wsf formates

we can read .del file
May 25 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by ED | last post: by
3 posts views Thread by Cynthia | last post: by
6 posts views Thread by Kevin Humphreys | last post: by
3 posts views Thread by =?Utf-8?B?YzY3NjIyOA==?= | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.