Re: dBASE (xbase) to Informix

->From: discovery!decello (Joseph P DeCello III) ->Subject: dBASE (xbase) to Informix ->Date: 7 Mar 1994 19:42:45 GMT ->Reply-To: discovery!decello (Joseph P DeCello III) ->Organization: Michigan State University, CADD/GIS System -> ->We're looking at Informix to setup a single database for plant records ->at MSU (and other stuff). Currently, all the information is in ->dBASE IV V2.0. Is it reasonable to assume that I'll be able to get the ->data from *.dbf files to Informix without retyping any of the data. -> ->I realize it may be semi-automatic at best, maybe running reports from ->dbase to ASCII files, then importing these into Informix. -> ->I wouldn't mind use PERL w/ informix enxtentions to do most of this. -> ->Is there PERL for informix (ie like sybperl for SYBASE)? -> ->I need to assure others here, that this indeed will be feasible before ->convincing them to switch to any Unix based database system. -> ->Thanks, -> ->Joe ->=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ->Joseph P. DeCello III **Computer Asst.** Email: decello@cad.msu.edu ->Michigan State University CPP Phone: (517) 355-9582 -> Dept. of Campus Park and Planning hours: MWF 8-11,2-4 EDT Informix has a powerful utility called DBLOAD that will read fixed format ASCII files, such as xbase reports written without headings and footings, and load data therein into a database. You create a control file, which specifies which character columns comprise data fields. With a clever control file, data fields can be reordered, duplicated, etc., during data loading. It is also possible to load data using the SQL LOAD command, which uses a "|" character as field delimiter. Since xbase will output comma separated value files, you might be able to manipulate these to be acceptable to the LOAD command. Overall, I think using DBLOAD is more straight forward. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\