Prev: SQL0818N after V7 -> V8 migration.
Next: NULLID.SYSSN300
From: anwar on 22 Mar 2006 03:09
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

From: Brian Tkatch on 22 Mar 2006 08:32
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.

From: Tonkuma on 22 Mar 2006 13:17
export to curdate.txt of del modified by nochardel select current
timestamp from sysibm.sysdummy1

 | 
Pages: 1
Prev: SQL0818N after V7 -> V8 migration.
Next: NULLID.SYSSN300