RE: 4GL merge
Art-
Your right, I shouldn't have answered without a quick look at
the syntax section of the manual.
--EEM
> -----Original Message-----
> From: Art S. Kagel [mailto:kagel@BLOOMBERG.NET]
> Sent: Wednesday, July 19, 2006 3:06 PM
> To: hendrickq@hotmail.com; Informix List (comp.databases.informix)
> Subject: Re: 4GL merge
>
> Everett Mills wrote:
> > Hendrick-
> >
> > Do you mean "Can I add more rows to a temp table I've already
> > loaded?" If you do then try this:
> >
> > SELECT mycolumns FROM mytable
> > WHERE whatever = whateverelse
> > INTO TEMP my_temp_table> >
> > ... lines of other code
> >
> > SELECT mycolumns FROM mytable
> > WHERE whatever = whateverelse
> > INTO my_temp_table> <SNIP>
>
> No, you cannot use INTO TEMP with an existing table. That clause
wants to
> create a new table. However, once the first statement runs and the
temp
> table exists, you can use INSERT INTO ... SELECT ... FROM; syntax:
>
> INSERT INTO my_temp_table
> SELECT mycolumns FROM mytable
> WHERE whatever = whateverelse;>
> Art S. Kagel
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list