Re: Reading ASCII files into INFORMIX environment

In article <29mb14$nnq@spool.mu.edu> andyw@studsys.mscs.mu.edu (Andy Whitcroft) writes: } I need you thoughts and suggestions, on the following: } } I need to read in an ASCII file from the unix file system. The ASCII } file only has CR/LF at the end of row, and NO delimiters. I have tried } use the LOAD ... INSERT INTO statement, but it insists on delimiters. } } So the question is, how do I read this file from the unix file system } in to a temp table using only INFORMIX, and UNIX utilities. } Read up on the DBLOAD utilitiy. The info can be found in the Appendix of SQL/4GL/ESQL manuals. It even gives an example on how to read fixed-field format files. DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.16 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com