Append data to file using export

[a***@fiserv.com]

Hi All,

Is there any way to append to a text file using EXPORT command of DB2?

Thanks

[Blair Kenneth Adamache]

For this, don't use export - just use a select statement from the
command line processor and pipe it to a file:

C:\tmp>db2 -z out.txt select * from adamache.employee

help:

C:\tmp>db2 ? options

Option Description Default Setting
------ ---------------------------------------- ---------------
...
-z Save all output to output file OFF

Notes:
Use the DB2OPTIONS environment variable to customize option default
A minus sign (-) immediately following an option letter turns the o
Use UPDATE COMMAND OPTIONS to change option settings in interactive
file input mode.

Post by a***@fiserv.com
Hi All,
Is there any way to append to a text file using EXPORT command of DB2?
Thanks