create Temp

[03Explorer]

Can someone help with the syntax for both CREATE TEMP and SELECT INTO TEMP.

I am being tasked with Informix SQL coding and my background is heavy with MS SQL Server.

Thanks.

 

[PHV]

1)
CREATE TEMP TABLE yourTable(
yourCarCol CHAR(50)
,yourIntCol INT
)

2)
SELECT yourColumnsList
FROM yourTablesList
WHERE yourExpression
INTO TEMP yourTempTable

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[03Explorer]

I am stumped with this simple statement...

any reason for failure?

 CREATE TEMP TABLE #sid (ordBy INT, lname char(10), fname char(10) )
insert into TABLE #sid Values(1, 'Smith', 'Jackson')

 

[olded]

You did 3 things wrong:

CREATE TEMP TABLE sid (ordBy INT, lname char(10), fname char(10) );
insert into sid Values(1, 'Smith', 'Jackson');
select * from sid;

1) With Informix, the # sign is not a valid character in a table name.
2) Separate your DML statements with a semi-colon
3) Lose 'TABLE' on the insert statemnet