By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,514 Members | 1,702 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,514 IT Pros & Developers. It's quick & easy.

Exporting current system timestamp to unix server

P: n/a
Hi all,

Im trying to extract db2 server current system timestamp from unix
shell script. So from shell script call the export command " db2
export to curdate.txt of del modified by chardel' ' select current
timestamp from sysibm.sysdummy1".

when i run the script im getting error curdate.txt file or directory
does not exsist...
but if i remove the modifier "modified by chardel' '", then system
timestamp is getting exported to text file.
I dont where im going wrong.

Anwar

Mar 22 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
This does not answer your question. Just a note. You can use:

db2 -x values CURRENT TIMESTAMP

and redirect the output to a file if needed. I do not think you need to
use export here.

B.

Mar 22 '06 #2

P: n/a
export to curdate.txt of del modified by nochardel select current
timestamp from sysibm.sysdummy1

Mar 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.