
November 1st, 2007, 12:48 AM
|
|
Registered User
|
|
Join Date: Nov 2007
Posts: 2
Time spent in forums: 9 m 32 sec
Reputation Power: 0
|
|
|
Export function fails on DB2 v7.1
Hi All,
I have DB2 v7.1 running on my linux machine.
It try to export my data from my table using EXPORT function but fails.
But the strange is when I run it on my local machine running DB2 v9 express under Windows XP, it run perfectly!!
This is the SQL =
export to '/home/db2inst1/db2-migrate/MYTABLE01.del' of del modified by timestampformat="yyyy-mm-dd hh:mm:ss" select * from MYTABLE01
the error message I got from my DB2 v.7.1 (on linux) =
SQL3016N An unexpected keyword "timestampformat=" was found in the filetmod.
parameter for the filetype.
Is it because the version issue (incompatible)??
Any comments really appreciated.
Thanks.
Regards,
Lanes
|