Re: Trying to use a SELECT ...INTO Command with InterBase, Sybase, and Informix

On Fri, 2 Oct 1998 12:11:03 -0500, "Peter DeSimone" <pdesimone@sageus.com> wrote: >SELECT TSP_COMPONENTS.ID LEVEL0ID, TSP_COMPONENTS.NAME LEVEL0NAME, >TSP_COMPONENTS.ABBREVIATION LEVEL0Abbreviation >FROM TSP_COMPONENTS >WHERE (((TSP_COMPONENTS.COMPONENT_LEVEL)=0)) >INTO Level_0 > >I want to take the data from the SELECT'FROM'WHERE SQL Statement and put it >into a new table called LEVEL_0. The Interactive SQL tool doesn't like the >INTO command. Everything else in that SQL statement works fine. IIRC the syntax on Informix is: insert into Level_0 select ... where ...;if the table exists and select ... where ... insert into temp Level_0; if you are using a temporary table Axel -- Sie haben die Position des Mauszeigers veraendert. Starten Sie Windows neu, damit die Aenderungen wirksam werden.