Re: Importing fixed-length ASCII data
Posted in 1992
David Ranney — — source: Informix-list mailing list archive (1991-1998)
In article <8781@emory.mathcs.emory.edu> trammel@riogrande.cs.tcu.edu writes: }Forwarded from Shane Trammel <trammel@riogrande.cs.tcu.edu>: } }I need to import a fixed length ascii file into a database. } }My problem: I only want certain fields to be imported, not the }whole thing. Can I selectively pick the fields I want. } }i.e f0 1-30 { name } } f1 50-60 { address } } f2 100-115 { company } } }Could someone please give me the proper systanx if it is }possible to do what I am describibg. } } }Thanks } }Shane Trammel }email: trammel@riogrande.cs.tcu.edu DBLOAD is tailor made to do what you want. You can read up about it in the indexes of the 4gl or sql manuals.