Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2007
    Posts
    1

    Unanswered: Export DB2 table problem

    Hi All.
    I am trying to create copy of very important table in my database.
    I am trying to do so with export command like this:
    "db2 export to /tmp/backup-db2/presrules.del of del messages /tmp/backup-db2/msg.txt select * from presrules"
    My table contains XML column.
    But when i run this script i get an error:
    SQL3022N An SQL error "-104" occurred while processing the SELECT string in
    the Action String parameter.
    Can anybody help me to solve my problem please.

    With Regards Koby.
    Last edited by koby75; 12-02-07 at 08:14.

  2. #2
    Join Date
    Jun 2006
    Posts
    471
    check the export syntax and try to specify
    -XML TO----xml-path-+-' '-XMLFILE----filename-+-'
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

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