How to export resultset to CSV

[babdya]

Hi there,
I need to extract huge amount of data from a DB2 dabase periodically.
The extracted data needs to be exported to CSV format. I have thought
of writing a Java piece of code to connect to DB2 using JDBC and then
execute various queries.
Is there any in-built functionality using which I can export the query
resultset to CSV ?

Thanks

Sumukh

[Arun Srinivasan]

On Aug 9, 3:38 am, [e-mail] wrote:

Hi there,
I need to extract huge amount of data from a DB2 dabase periodically.
The extracted data needs to be exported to CSV format. I have thought
of writing a Java piece of code to connect to DB2 using JDBC and then
execute various queries.
Is there any in-built functionality using which I can export the query
resultset to CSV ?

Thanks

Sumukh

The EXPORT command will do what you want to..

[dotyet]

There is just one issue though. You are limited to only 254
characters. So, if you have a varchar of length 500, you will lose 256
characters in the export. I dont know if this limitation has been
removed from V9 or not, but I still face it on our V8 FP 14.

Regards,
dotyet

On Aug 9, 10:41 am, Arun Srinivasan <[e-mail]:

On Aug 9, 3:38 am, [e-mail] wrote:

Hi there,
I need to extract huge amount of data from a DB2 dabase periodically.
The extracted data needs to be exported to CSV format. I have thought
of writing a Java piece of code to connect to DB2 using JDBC and then
execute various queries.
Is there any in-built functionality using which I can export the query
resultset to CSV ?

Thanks

Sumukh

The EXPORT command will do what you want to..

[babdya]

Thanks everybody..

On 9 Aug, 21:37, dotyet <[e-mail]:

There is just one issue though. You are limited to only 254
characters. So, if you have a varchar of length 500, you will lose 256
characters in the export. I dont know if this limitation has been
removed from V9 or not, but I still face it on our V8 FP 14.

Regards,
dotyet

On Aug 9, 10:41 am, Arun Srinivasan <[e-mail]:

On Aug 9, 3:38 am, [e-mail] wrote:

Hi there,
I need to extract huge amount of data from a DB2 dabase periodically.
The extracted data needs to be exported to CSV format. I have thought
of writing a Java piece of code to connect to DB2 using JDBC and then
execute various queries.
Is there any in-built functionality using which I can export the query
resultset to CSV ?

Thanks

Sumukh

The EXPORT command will do what you want to..- Hide quoted text -

- Show quoted text -