Re: Reading ASCII files into INFORMIX environment

andyw@studsys.mscs.mu.edu (Andy Whitcroft) writes: >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. the Informix dbload utility might do what you want it to; it can used fixed length fields and other things load won't. See the Informix-SQL manual for more. It is a utility provided with the database engine, not a separate product. ================ Dennis J. Pimple Informix CSE / Denver