Re: CLP export file with date stampThis is a discussion on Re: CLP export file with date stamp within the db2-udb forums in Other Databases category; Hi, 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 : file= myFile_ `date + %F `.txt;db2 export to $file of del select * from employee Gajanan Deogirikar... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
11-22-2007, 06:20 AM
|
 Re: CLP export file with date stamp Hi, 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 : file="myFile_"`date +"%F"`.txt;db2 "export to $file of del select * from employee" Gajanan Deogirikar  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 05:49 AM.
