Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    57

    Unhappy Unanswered: Import data - order list

    Hello all!

    I'm trying to find out how to get an ordered list of all tables to import data in db according to foreign keys that exist. I don't have idea how to do that...

    Thank you in advance,
    NNicole

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Normally you would drop the constraints, load data, and then re-create the constraints.

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    NNicole
    If you do not want to drop the FKs, I posted on this forum a query to get what you want. You can locate it here also:

    http://www.db2click.com/scribble.htm

    Andy

  4. #4
    Join Date
    May 2003
    Posts
    57
    I know that way, but I'd like to exclude data that doesn't "fit" before I import them. Not exactly exclude rows, just to see where (on what tables) db rejects to import because of ref. integrity...

Posting Permissions

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