Re: external tables with Informix > 7.24

---- you wrote: > Hi everybody, > > 1. I've got the problem of dealing with external files in INFORMIX. I > heard that there's a command "CREATE EXTERNAL TABLE" in Informix, > allowing to declare a file as a table. Does anyone know about it? I think that's only with ADSO Dude. It might be in IDS2000? You can read flat files directly with ACE though. > 2. Is there a way to produce a file containing the result of a > SELECT-statement in fixed-length format, one record per line? Sure Dude, just use: UNLOAD TO "myfile" DELIMITER ""SELECT col1 || col2 || col3 || col4 FROM mytable AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com