Groups > DB2 > DB2 UDB > Re: CLP export file with date stamp




Re: CLP export file with date stamp

Re: CLP export file with date stamp
Thu, 22 Nov 2007 05:20:32 EST
Hi,<br />
<br />
You need to do a trick with few OS Commands (if you are working on Linux). Issue
following command on $ prompt for exporting a table :<br />
<br />
file="myFile_"`date +"%F"`.txt;db2 "export to $file  of
del select * from employee"<br />
<br />
Post Reply
about | contact