Re: Informix & REMEDY

In article <3k4vng$2d7@cssun.mathcs.emory.edu>, rsuggs@huachuca-giis.army.mil ("Randall D. Suggs") says: > >Our organization uses a trouble ticket creation and tracking application >called Action Request System from REMEDY Corp. Currently, the data is >stored in flat files. We want to convert from flat files to Informix-SE >or OnLine. The documentation suggests this is an easy task. > >Has anyone gone through this process? If so, I'd appreciate any insights >(thoughts, comments, suggestions) you might have. > >Thank you, >Randy I think you probably need to use the dbload utility, I've used it with S.E. to load flat file data into Informix tables. You will need some consistancy with columns, either a fixed seperator such as | or ' though you can do some clever things and count the number of characters for each column or field. I seem to remember that dbload is described reasonably well in the manuals If you get really stuck I could probably do it for you. Cheers Dave Ingledew Southampton U.K.