Re: Temporary tables

Chuck Mattern (cmattern@netcom.com) wrote: : I'm new to Informix coding and off on my first mission. I need to : unload the contents of a table at a remote location to an ascii file, : ftp it to my location and load it into a temporary table for viewing. : Once the application is exited the table and the file should be : deleted. The unload, ftp and disposition of the ascii file are obvious, : any pointers on the local business? Also there may be several users in : the application at the same time so each would need to have their own : unique temp table. : All thoughts welcome here... : Chuck If I read your question correctly, CREATE TEMP TABLE.... in your application should do the trick. Several users can use the same table name as the temp table is local to the current database session. I can only vouch for SE by the way. Hope this helps. regards, Scott. Scott McClintock - MU Systems Pty Ltd - Brisbane Australia. scott@musys.mpx.com.au