SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 08:23 PM
| ||||
| ||||
 FW: Whatcha' wanta have????? Be able to add the definition of a temp table to the system catalogs so that it's not necessary to define the table in the application. I would like it to be possible to set it 'not logged'. The table should automatically be created when it is referred too in a select, update or delete. This would be a great help for improving performance of off-the-shelf apps which create 'permanent' tables to hold temporary data for processing purposes. Mark sending to informix-list sending to informix-list      |
|
04-19-2008, 08:23 PM
| ||||
| ||||
| Re: FW: Whatcha' wanta have????? Mark Denham wrote: > Be able to add the definition of a temp table to the system catalogs so > that it's not necessary to define the table in the application. I would > like it to be possible to set it 'not logged'. The table should > automatically be created when it is referred too in a select, update or > delete. > > This would be a great help for improving performance of off-the-shelf > apps which create 'permanent' tables to hold temporary data for > processing purposes. > > Mark > > sending to informix-list > > > sending to informix-list Created global temporary tables. They are in the SQL standard :-) -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab |
Linear Mode
