Reading ASCII files into INFORMIX environment

Posted in 1993

Andy Whitcroft — 15 Oct 93 14:10:44 GMT — source: Informix-list mailing list archive (1991-1998)

Hi netlanders, 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. I will not use a C function to solve the problem, because I am about to upgrade from Solaris 1.1 to Solaris 2.2 ( which has no C compiler ). Please email to me your thoughts and suggestions, if there is enough interest I will post the respones. Andy.