Re: Some SQL-Questions!

Carlson@WHSmith wrote: > > Magnus Westling wrote: > > > > Does anyone know the syntax for creating temptables in informix. I know how it works in sybase? > > > > /Robert > > try > > SELECT col1, col2, col3 > FROM tab_a > WHERE {wherever} > into temp (temptable name) Or CREATE TEMP TABLE mytable ( mycol1 char(2), mycol2 integer ) WITH NO LOG; The WITH NO LOG is optional. You can use it in the SELECT stement, too. The manuals explain this quite clearly. Referring to the index under TEMP will put you right. This is what indexes are for, even in books. ;-). "If all else fails, read the manual." -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/