Re: Informix Temp Table, help needed
SELECT column_list
FROM table_list
WHERE conditions_list
INTO TEMP temp_table_name ?????
--- lachlan Dunlop <lach@lach.net> escribi': > Hello,
>
> I am trying to use informix temp tables. I am
> having a hard time
> finding information on how to implement them.
>
> I have multiple seemingly unrelated select
> statements, which I want the
> results to go into 1 row of a temp table. Can this
> be done with
> Informix?
>
> How would I have Informix create this for me?
>
> Thanks
>
> Lach
>
=====
______________________________________Luis Carlos D'az OteroALCANOS DE COLOMBIA S.A. E.S.PCarrera 9 # 7-25Neiva (Huila (Colombia))
_________________________________________________________
Do You Yahoo!?
Obtenga su direcci'n de correo-e gratis @yahoo.com
en http://correo.espanol.yahoo.com
CREATE TEMP TABLE temp_table_name (
column1 type,
column2 type,...
);
Then use standard insert and update statements to the table as if it
where a normal table.
In article <8tuh96$ai9$1@news.xmission.com>,
=?iso-8859-1?q?Luis=20Carlos=20Diaz=20Otero?=
<luiscarlosdiazo@yahoo.com> wrote:
>
> SELECT column_list
> FROM table_list
> WHERE conditions_list
> INTO TEMP temp_table_name ?????>
> --- lachlan Dunlop <lach@lach.net> escribi': > Hello,
> >
> > I am trying to use informix temp tables. I am
> > having a hard time
> > finding information on how to implement them.
> >
> > I have multiple seemingly unrelated select
> > statements, which I want the
> > results to go into 1 row of a temp table. Can this
> > be done with
> > Informix?
> >
> > How would I have Informix create this for me?
> >
> > Thanks
> >
> > Lach
> >
>
> =====
> ______________________________________Luis Carlos D'az OteroALCANOS
DE COLOMBIA S.A. E.S.PCarrera 9 # 7-25Neiva (Huila (Colombia))
>
> _________________________________________________________
> Do You Yahoo!?
> Obtenga su direcci'n de correo-e gratis @yahoo.com
> en http://correo.espanol.yahoo.com
>
Sent via Deja.com http://www.deja.com/
Before you buy.