load text files to DB2 dbase

[jmarr02s]

Hi,
I am trying to load comma delimited text files (data originates from
an MS Access database) to a DB2 database.

I have come to the conclusion, based on errors such as:

SQL0530N The insert or update value of the FOREIGN KEY constraint-name
is not equal to any value of the parent key of the parent
table.......... ..........that the parent table is the key to solving
the problems with my code, data and databases.

Only problem is I have to go thru someone else to access this parent
table.

Any suggestions how to solve this problem when I do gain access to
this parent table?

Thanks a gigallion!

John

[Lennart]

Re: load text files to DB2 dbase

On Jan 11, 10:54 pm, jmarr02s <john.marru...@ illinois.govwro te:

Hi,
I am trying to load comma delimited text files (data originates from
an MS Access database) to a DB2 database.
>
I have come to the conclusion, based on errors such as:
>
SQL0530N The insert or update value of the FOREIGN KEY constraint-name
is not equal to any value of the parent key of the parent
table.......... ..........that the parent table is the key to solving
the problems with my code, data and databases.
>
Only problem is I have to go thru someone else to access this parent
table.
>
Any suggestions how to solve this problem when I do gain access to
this parent table?
>
Thanks a gigallion!
>

You must add data to the parent table(s) before you can import the
failing rows into your table. One way to figure out which data you are
missing is to create a temp table like your target table, import your
data there, and use sql to find out which parent data you are
missing.

/Lennart