Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
can I make current timestamp to be part of the export file name?
- Thread starter BeardBear
- Start date
sathyarams
IS-IT--Management
AFAIK, it is not possible.
I would like to be proved wrong, though
The option is to use a shell/batch script to generate export stmts before executing
For db2 resoruces visit More DB2 questions answered at &
I would like to be proved wrong, though
The option is to use a shell/batch script to generate export stmts before executing
Code:
date +"%Y%m%d_%H%M%S"
echo "export to file_$now.ixf of ixf select * from table" > export.db2
db2 -tvf export.db2For db2 resoruces visit More DB2 questions answered at &
sathyarams
IS-IT--Management
date +"%Y%m%d_%H%M%S" should have been
now=date +"%Y%m%d_%H%M%S"
For db2 resoruces visit More DB2 questions answered at &
now=date +"%Y%m%d_%H%M%S"
For db2 resoruces visit More DB2 questions answered at &
- Status
Similar threads
- Locked
- Question