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

extracting db2 table records to csv

P: n/a
Hi all,

I have a task to extract DB2 table data to csv file from shell script.
i have to execute a sql query and the retreived data should be moved to
csv file. If i get a solution, ll be very much thankful

regards
Anwar

Mar 16 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
"anwar" <an********@gmail.com> wrote in message
news:11**********************@j52g2000cwj.googlegr oups.com...
Hi all,

I have a task to extract DB2 table data to csv file from shell script.
i have to execute a sql query and the retreived data should be moved to
csv file. If i get a solution, ll be very much thankful

regards
Anwar


Use the export command. The SQL statement to determine which columns and
rows you will pull is part of the export command syntax. See the Command
Reference manual for details.
Mar 16 '06 #2

P: n/a
I dont have pdf for command reference manual. im new to DB2 and can you
tell me from where i can d/l these reference manual

Mar 17 '06 #3

P: n/a
anwar wrote:
I dont have pdf for command reference manual. im new to DB2 and can
you tell me from where i can d/l these reference manual


The Info Center (which includes the reference manual) for DB2 UDB for
Linux/Unix/Windows can be found at:

http://publib.boulder.ibm.com/infoce...w/v8/index.jsp

The Info Center for DB2 UDB for z/OS can be found at:

http://publib.boulder.ibm.com/infoce...v2r2/index.jsp

Alternatively, you can download PDFs of the manuals at:

http://www-306.ibm.com/software/data...manualsv8.html

There are translated versions of the PDFs available at:

http://www-306.ibm.com/software/data...ualsNLVv8.html

Personally, I'd stick with the Info Center -- it's updated with the
latest information for FixPaks (if you see light blue numbers down the
left of a document it indicates the information is specific to a Fixpak
level), and has a pretty good search facility. If there's a downside,
it's that it's so vast it can be difficult to find things at first
(until you get used to the structure). The sections I find most useful
are the Commands, Messages, and SQL sections under the Reference
section.

Incidentally, the documentation for the EXPORT command is available in
the following section of the Info Center:

Reference / Commands / DB2 Universal Database / Command Line Processor
(CLP) / EXPORT
HTH,

Dave.
--

Mar 17 '06 #4

P: n/a
Thankx very much dave

Anwar

Mar 21 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.