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.sysdummy 1".

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

[Brian Tkatch]

Re: Exporting current system timestamp to unix server

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.

[Tonkuma]

Re: Exporting current system timestamp to unix server

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