Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / January 2008

Tip: Looking for answers? Try searching our database.

load text files to DB2 dbase

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jmarr02s - 11 Jan 2008 21:54 GMT
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 - 11 Jan 2008 22:05 GMT
> Hi,
> I am trying to load comma delimited text files (data originates from
[quoted text clipped - 14 lines]
>
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.