Re: Database utility

Quoting RUCHI@CFRVM.CFR.USF.EDU... > > I have two ascii files that contains two diffrent set of data with one common > key. How would I load into database? I used the DBLOAD command to load the firs > t ascii file but how would I load the second set of ascii file to merge with > existing data. > Is this common key in both ascii files? It will make life for you a lot easier if it is. If not, you'll have to load the second file into your database and manually go in and insert the key data so that the tables will join. If the key data is in both ascii files, then all you have to do is load the second file and start selecting data with: SELECT * FROM table1, table2 WHERE table1.key_column = table2.key_column DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.2 UUCP: ..!uunet!das13!dave INTERNET: Dave.Snyder@snide.com