Need to export table to an Excel file

[Massimiliano Campagnoli]

I need to export some tables to an excel file inside a REXX unattented
script that run periodically.

I've tried the command :

DB2 EXPORT TO MYFILE.WSF OF WSF SELECT * FROM MY_TABLE

but it does not work with rows above 2048 and it does not copy column
header.

[Serge Rielau]

Massimiliano Campagnoli wrote:

I need to export some tables to an excel file inside a REXX unattented
script that run periodically.

I've tried the command :

DB2 EXPORT TO MYFILE.WSF OF WSF SELECT * FROM MY_TABLE

but it does not work with rows above 2048 and it does not copy column
header.

The column header you could add with a UNION ALL (would require to cast
all columns to strings though.
I'm unclear of the source of our 2048 limit. That's nothing I've veer
heard of.
Can you define "does not work"?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/