Export function fails on DB2 v7.1

[l***@yahoo.com]

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

[Ian]

Post by l***@yahoo.com
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.

Read the documentation for the export command (from V7.1)! It should be
pretty obvious why it's complaining about the timestampformat
file-type-modifier. (Hint: It didn't exist in DB2 v7.x)

[l***@yahoo.com]

Hi Ian,

Thank you.

Regards,
Marthen

[Knut Stolze]

Post by Ian

Post by l***@yahoo.com
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.

Read the documentation for the export command (from V7.1)! It should be
pretty obvious why it's complaining about the timestampformat
file-type-modifier. (Hint: It didn't exist in DB2 v7.x)

That's what I also told him in another forum.