AllExperts > Ingres 
Search      
Ingres
Volunteer
Answers to thousands of questions
 Home · More Ingres Questions · Answer Library  · Encyclopedia ·
More Ingres Answers
Question Library

Ask a question about Ingres
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Jean-Pierre Zuate
Expertise
Any questions about database Ingres (owned by Computer Associates then Ingres Corp) : - Ingres 6.4 - OpenINGRES from 1.0 to 2.0 - IngresII from 2.0 to 2.6 - Ingres R3, Ingres 2006 (Open Source version) - All tool around Ingres : ABF, Report Writer, Replicator, OpenROAD (3.5 to 2006), Ingres/NET Ingres/STAR, ...

Experience
16 years of computing experience as :
- AS400 programmer
- AIX / Ingres administrator and developer (OpenROAD and korn shell)
- Ingres DataBase Administrator
- Ingres expert - Data modelisation - ETL - Reporting - Many of Computer Associates sofwares - ITIL / CMDB / Change Management

Organizations
http://lafageconseil.fr

 
   

You are here:  Experts > Computing/Technology > Databases > Ingres > Ingres Star

Ingres - Ingres Star


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

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

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.