|
| Re: Export function fails on DB2 v7.1 |
 |
Fri, 02 Nov 2007 11:06:09 +010 |
Ian wrote:
> lanesbalik@yahoo.com wrote:
>> 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.
--
Knut Stolze
DB2 z/OS Utilities Development
|
| Post Reply
|
|
|
|
|
|
|
|
|
|