Oninit cdi / Archive
Talk to an expert →

insert into temp table

Posted in 2003

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Versions, Editions & End-of-Life

Dhiren_Dave@ril.com — — source: Usenet: comp.databases.informix

Hi V R using IDS 7.31 on sco platform and Informix -4Gl 7.20 UD7. One of our developer want to load flat file [ ascii file ] in to the temp table created within the program. can any body help me. sorry for poor english. Thanks sending to informix-list

↪ replying to Dhiren_Dave@ril.com
P Travis — — source: Usenet: comp.databases.informix

Use LOAD FROM <filename>INSERT INTO <tablename> Note: Temp table must already exist. If flat file is not delimited with the | character then use LOAD FROM <filename> DELIMITER <delimiter>INSERT INTO <tablename> Example: LOAD FROM "data.txt" DELIMITER "," INSERT INTO tmp_table Dhiren_Dave@ril.com wrote in message news:<bde2t0$kn0$1@terabinaries.xmission.com>... > Hi > V R using IDS 7.31 on sco platform and Informix -4Gl 7.20 UD7. One of > our developer want to load flat file [ ascii file ] in to the temp table > created within the program. > can any body help me. sorry for poor english. > > Thanks > > > sending to informix-list

Glossary