467,887 Members | 1,574 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,887 developers. It's quick & easy.

Exporting current system timestamp to unix server

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
  • viewed: 2163
Share:
2 Replies
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
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.

Similar topics

2 posts views Thread by Ben | last post: by
9 posts views Thread by Leo Breebaart | last post: by
reply views Thread by Casey | last post: by
2 posts views Thread by In. Martin PrŠĻek | last post: by
4 posts views Thread by Mark Harrison | last post: by
7 posts views Thread by Damir | last post: by
2 posts views Thread by Ashit Vora | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.