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

Since V7 is out of service for nearly 2 years now, I didn't bother to check the manuals. But I would say that V7 simply did not support that keyword - as the message says.

I recommend that you move to V8 - or better yet V9.

Hi Stolze,

Yup, i think so.
Because i had tried the export function with "modified by coldel;", it does work properly.

Thanks any way.


Regards,
Lanes