Question We are migrating from Ingres II to Ingres 2006 from single production to multiple databases with a DDB.
1. Now on running the application (having Global Temporary tables concept in LDB's) we get error that Global temporary tables not supported by Ingres Star.
2. Also, we have left and outer joins. Even these frames also donot work.
Any advise please?
Thanks and Regards,
Mrs Raghavan
Answer Hello,
Unfortunaly I have no particular advice except breaking your concept (and I know it is not marvellous at all) : playing localy with your global tables and outer joins.
I mean insert into a local temporary table the star table, do the job localy (gtt and outer joins) and then update your star tables if needed.
For example and with an other subject you can have benefits to do that. In a report writer environment applications traditionnaly fill up a temporary table (not a global temporary but a real table starting with tmp_) and then print this temporary tables. Then we can modify statement to do the job in a GTT table and at the end insert the GTT content into the temporary table (starting by tmp_).
In your case you perhap's can imagine to do the job localy (has I said) in a GTT table and at the end revert to the original statement.
Not sure I'm clear, tell me if you need more explanation ...
