Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2015
    Posts
    2

    Unanswered: can we export all the tables from database which is having lobs and also non lobs

    Hi

    Can we export all the tables from database which is having lobs and also non lobs using single query, if it is possible can any post the query

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    db2move mydb export
    can do this.
    Regards,
    Mark.

  3. #3
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    Keep in mind that once the data is outside of DB2 it is less secure, if UTF-8 it is prone to unintentional codepage conversions, so if your intention is to copy that data into another database then you might consider a more secure method (such as federation, or remote load from cursor or backup/restore etc).
    Last edited by db2mor; 05-06-15 at 10:44.

Posting Permissions

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