Expert: Jean-Pierre Zuate - 12/5/2008

Question
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 ...

Hope this help you.

Best regards,
Jean-Pierre Zuate
http://lafageconseil.fr

---------- FOLLOW-UP ----------

QUESTION: Hi,
Do you mean that if we issue commands like
create table xx as select * from  aa; commit;
create table xx1 as select ... from bb m, xx n where m.vv=n.vv......;
commit;
then where are the tble created in ldb or ddb?
unfortunately it creates xx in ddb, and the next xx1 does not get created anywhere.

also at the end drop table xx does not drop from ddb.

any possible help please?

Mrs Raghavan


Answer
Hello,

First, sorry for my late reply.

I'am not a full expert on Ingres/Star and I could not help you anymore without examples.

Could you extract some materials from your issue ? I mean table script creation, test case explaining what are the dbs and so on ?

Thank in advance.

Regards,
Jean-Pierre ZUATE
http://lafageconseil.fr