Exporting current system timestamp to unix server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anwar - 22 Mar 2006 09:09 GMT

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

Reply to this Message

Brian Tkatch - 22 Mar 2006 14:32 GMT

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.

Reply to this Message

Tonkuma - 22 Mar 2006 19:17 GMT

export to curdate.txt of del modified by nochardel select current
timestamp from sysibm.sysdummy1

Reply to this Message