At 11:25 PM 3/3/2011, TOM HART wrote:
Can you load a temp table from 2 or more files eg load temptable from file1.asc as ascii load temptable from file1.asc as ascii and so on
Tom, You mean file1.asc, file2.asc, and so on ... Loading file1.asc, file1.asc will certainly duplicate the load <g>. Yes, you can load a TEMP table from 2 or more files, as long as the ascii file meets the format of your temporary table structure. Keep in mind that all TEMPorary tables and views are automatically DROPped when using the CONNECT or DISCONNECT command. Very Best R:egards, Razzak.
