Exporting current system timestamp to unix server

anwar

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

Brian Tkatch

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

Tonkuma

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

Mar 22 '06 #3