Re: Informix Export

W. Russell Wakelin wrote: > > Hello, > > We're not using Informix, but we're dealing with a company that is. > They can send us a copy of their Informix database by doing a database > "export". > > My question: What does/will this export look like? Is it an SQL script > that can be loaded into another SQL DBMS? Call me "Mr. dbexport" today. I suspect the customer is referring to dbexport, which is a utility that comes with the engine that will create a set of files on disk (or directly to tape). The files are a doctored sql script that does the CREATE TABLE and LOAD statements, and a set of pipe-delimited files containing the data that the LOAD statements can read. There are too many options to predict exactly what the export will look like. I doubt if the files could be used to load another SQL DBMS. Ask the vendor to detail how they plan to export, and the relavent pages from the manuals on how to load it (and don't tell anyone in our docs group that I said you could photocopy manual pages) //////////////// ======================================================= ////////// // Dennis J. Pimple Informix Software, Inc. ////// / /// Principal Consultant 5299 DTC Blvd Suite 740 ///// // //// dennisp@informix.com Englewood CO 80111 //// // ///// /// // ////// recept: 303-850-0210 // // /////// direct: 303-740-5611 Opinions expressed are mine, / /////////// fax: 303-843-6408 and do not necessarily //////////////// http://www.informix.com reflect those of my employer