By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,609 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,609 IT Pros & Developers. It's quick & easy.

Export function fails on DB2 v7.1

P: 2
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
Nov 1 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.