Re: SELECT AND TEMP TABLES?
Ken McCoy wrote:
>
> Hello Again,
>
> Using the 5.05 ver. of the Informix Engine and OSF/1, is it possible to
> redirect a
>
> "SELECT col1,col2,col3 from table_name INTO TEMP temp_table_name
> WITH NO LOG"
>
> into anything other than the rootdbs?
>
> ---------
> Ken McCoy
> AR Public School Computer Net.Ken,
as I know it is not possible in Online 5.x to use another space than
rootdbs in a implicit temp table.The only alternative is to:
CREATE TEMP TABLE temp_table_name (...) WITH NO LOG IN dbspace_name
SELECT col1,col2,col3 INTO p_var.col1,p_var.col2,p_var.col3
INSERT INTO temp_table_name VALUES (p_var.col1,p_var.col2,p_var.col3)
Yours,
Tolis
+---------------------------------------------------------------------+
| Tolis Varnas email: tvarnas@compulink.gr |
| Deligiorgi 26 tvarnas@orbit.de |
| 546 42 Thessaloniki Voice: (30) 31 820270 |
| Greece Fax: (30) 31 865463 |
+---------------------------------------------------------------------+