By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,457 Members | 1,334 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,457 IT Pros & Developers. It's quick & easy.

DB2 export to flat file

P: 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
Share this Question
Share on Google+
1 Reply


P: 2
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.