Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2007
    Posts
    4

    Unanswered: 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

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Nov 2007
    Posts
    4
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •