Re: ** Another Challenge **

On Wed, 18 Jan 1995 anand@sin-co.sin-ro.DHL.COM wrote: > > The drop table statement works fine when the table exists, the only > > time you will get a -status error is when the table is created for > > the first time. That's what the WHENEVER ERROR CONTINUE statement > > is for. > > Your 'Drop Table' is different from the Table You are creating The 'drop table' statement should have been identical to the two sets of INSERT statements. If there was an error in my original posting I must apologise. The problem occurred on SCO 3.2.4, Informix 5.0 Rapid 4.1 We only use the WHENEVER ERROR CONTINUE statement to ignore the failure of the DROP TABLE statement the first time the function is called. I often use this technique to ensure the table is freshly created. There is a clear bug in the engine in that within a transaction the temp table is not being recreated properly. If the temp table is replaced with a real table, or the transaction is committed before the second set of statements, everything is fine. We appreciate your response. Neil @ storm.aztec.co.za