Re: [Q] Another SQL question???

Ed Schaefer writes: * In <47qglg$g02@tin.monsanto.com> Saqib Mausoof * <ssmaus@musctn.monsanto.com> writes: * > * >You guys have been extremely helpful, so I will have another go at * this * >;-) * > * >I have constructed the following query with the help of Net * God(esses). * > * >select col1, col2, col3 from table1 where col1="xyz" * >union * >select col1, col2, col3 from table2 where col1="xyz" * >into temp temp_table; * > * >select temp_table.col1, temp_table.col2, temp_table.col3, table3.col1 * >from temp_table, table3 * >where temp_table.col3=table3.col1 * > * >This works fine, except the data in table3 is being continuosly * updated * >so I need to run this query repeatedly. That is not a problem EXCEPT, * >once a TEMP table temp_table has been created, Informix gives an error * * >saying that the table still exists. ANY way around that???? * > * * Saqid: * * you must be using the standard engine. We have had probelms dropping * temp tables with standard engine so we have taken to deleting all the * rows from the temp table instead of re-creating it. Now, with the * online engine you don't have a problem dropping temp tables. Unless you are using Online 5.01. We've had no problems using SE for temp tables. Robert Minter Data Systems Support \\\\\\_/// Senior Software Engineer A Client Technologies Company ( _ _ ) E-Mail: rob@dssmktg.com Tel: 714.771.0454 (| ^ |) #include <disclaimer.h> Fax: 714.771.3028 \\`-'/ De Colores - Emmaus OC-13 SURF'S UP \\_/