You are here:
Ingres/Questions
| Subject | Date Asked | Expert |
| Ingres equivalent to Oracle Spool cmd | 1/19/2012 | Jean-Pierre Zuate |
| Q: I am wondering what is the Ingres SQL equivalent of the Oracle SQL commands: SPOOL filename SQL ... A: OK. What I do when I need statements such as the one you say, I do the following (in Unix shell, ... | ||
| Ingres equivalent to Oracle Spool cmd | 1/19/2012 | Jean-Pierre Zuate |
| Q: I am wondering what is the Ingres SQL equivalent of the Oracle SQL commands: SPOOL filename SQL ... A: I'am not sure spool have an exact equivalent ... For the Oracle DBA near me, spool is mainly used ... | ||
| problème redémarrage ingres | 10/7/2011 | Jean-Pierre Zuate |
| Q: Cher monsieur, je me permets de vous contacter car nous ne parvenons plus à redémarrer la base de ... A: Bonjour, Remote command ne sert qu'à la partie serveur de VisualDBA. Si vous ne pouvez pas voir ... | ||
| clone Ingres installation | 9/8/2011 | Jean-Pierre Zuate |
| Q: Back in 2007 You wrote about cloning Ingres installation. Did you tried that ? I need to install ... A: You, you should recreate them "manualy" or make a small program doing this. Help you with Ingres ... | ||
| Migration from Ingres to Oracle database | 8/9/2011 | Jean-Pierre Zuate |
| Q: how are you? I hope you're very well. Could you help us, please? Environment: Ingres AXP DEC UNIX ... A: Very quickly ... This message mean your Ingres/Net client could not reach the server. If you can ... | ||
| ingres configuration | 9/12/2010 | Melvin Davidson |
| Q: "hello, I have an Ingres 2006 on a server linux redhat 4.5 with about 100 users who use application ... A: The is no formula to determine the number of iidbm's you will need. Optimizing Ingres is specific ... | ||
| upgrading from ingres 6.4 ( 32 bit) to 9.2 (64 bit) | 7/27/2010 | Jean-Pierre Zuate |
| Q: I successfully reloaded the DB in test where ingres 9.2 is installed. How can I copy my ABF ... A: You can (and at least you must) use copyapp to export them from 6.4 and import them to 9.2. See ... | ||
| PROBLEM WITH OPF MEMORY | 6/8/2010 | Jean-Pierre Zuate |
| Q: Can you please inform me how can i resolve the problem of "optimize run out of memory" when i try to ... A: i don't know what is "cash memory" perhaps you mean swap space (vs ram space). yes of course it has ... | ||
| PROBLEM WITH OPF MEMORY | 6/7/2010 | Jean-Pierre Zuate |
| Q: Can you please inform me how can i resolve the problem of "optimize run out of memory" when i try to ... A: Whatever the Ingres version you use this message made me think to the parameter opf_memory. Increase ... | ||
| compatibility between Red Hat and ingres | 5/5/2010 | Melvin Davidson |
| Q: I'd like to know if the version of Ingres DBMS 9.0.4, 32bit is compatible with Red Hat 4.5 64bit. It ... A: Jean, I would not install a 32 bit version of Ingres in Red Hat 64 bit. It is better to install the ... | ||
| compatibility between Red Hat and ingres | 5/4/2010 | Jean-Pierre Zuate |
| Q: I'd like to know if the version of Ingres DBMS 9.0.4, 32bit is compatible with Red Hat 4.5 64bit. It ... A: I don't know what is the best Ingres release / OS release for your situation. The best way is to go ... | ||
| ingres installation | 5/2/2010 | Jean-Pierre Zuate |
| Q: I'd like to know what is the best architecture installation recommended performance side, knowing ... A: Simple question, deep answer. Things to consider to choose one or the other one are : - impact of ... | ||
| How to improve the speed of downloads | 3/3/2010 | Jean-Pierre Zuate |
| Q: I am downloading data from a table which contains more then 250 Million rows and the file size is ... A: You're welcome, and thank in advance for your future update. Take care not to forget data in your ... | ||
| How to improve the speed of downloads | 3/3/2010 | Jean-Pierre Zuate |
| Q: I am downloading data from a table which contains more then 250 Million rows and the file size is ... A: unfortunatly i don't see anything that can help you. I've no real experience of so huge table, but ... | ||
| Ingres/ABF | 3/1/2010 | Melvin Davidson |
| Q: I am new to Ingres and also ABF. I am into new project where i need to work on Tngres with ABF. I ... A: Banu. Your question is very general in nature. However, I can recommend that you download the ... | ||
| delimiter question | 1/9/2010 | Jean-Pierre Zuate |
| Q: I am getting the below error when trying to set the delimiter from colon to semicolon. Can you ... A: Ok I know now where your SQL sentence is wrong. It is because of c0. It seems it did not support ... | ||
| delimiter question | 1/8/2010 | Jean-Pierre Zuate |
| Q: I am getting the below error when trying to set the delimiter from colon to semicolon. Can you ... A: Have you read the documentation ? The part you are looking for is in the SQL Guide of Ingres. A ... | ||
| delimiter question | 1/8/2010 | Jean-Pierre Zuate |
| Q: I am getting the below error when trying to set the delimiter from colon to semicolon. Can you ... A: Try this : - set lockmode session where readlock = nolock (omit the ';' cause here you set the value ... | ||
| fetching data!! | 12/29/2009 | Jean-Pierre Zuate |
| Q: thank you for your help! A: Talend is good way to acheive this. If you want to use Ingres tools, the path is to study the ... | ||
| besoin d'aide | 12/29/2009 | Jean-Pierre Zuate |
| Q: Bonjour Mr, J'espére que vous allez bien ...!! J'ai besoin de votre aide si c'est possible .. J'ai ... A: Alors je ne vois qu'une explication : la différence de SQL qui peut exister entre une version de ... | ||
| ingres to oracle | 12/29/2009 | Jean-Pierre Zuate |
| Q: I would like to know how to migrate data to a base that is under unix "ingres aix 5.2) to another ... A: OK, sorry, but Talend was also a good answer. If you want to use Ingres tools, the path is to study ... | ||
| ingres to oracle | 12/29/2009 | Jean-Pierre Zuate |
| Q: I would like to know how to migrate data to a base that is under unix "ingres aix 5.2) to another ... A: I don't know at all what are best practices for migration from Ingres to Oracle. Ask this question ... | ||
| besoin d'aide | 12/29/2009 | Jean-Pierre Zuate |
| Q: Bonjour Mr, J'espére que vous allez bien ...!! J'ai besoin de votre aide si c'est possible .. J'ai ... A: Bonjour, Je vais bien merci, et vous ? (et qui êtes vous ? ertyui c'est un peu vague ...:) Essayez ... | ||
| temporary table | 12/10/2009 | Melvin Davidson |
| Q: This is an example as you have asked me: declare query=varchar(2000)NOT NULL; enddeclare query ... A: Azerty, I believe I asked for the exact statement your were using, not an "example". Your example: ... | ||
| temporary table | 12/7/2009 | Melvin Davidson |
| Q: At this moment I am working on a project to optimize the database ingres 2006 [9.2.0] and ‘queries’ ... A: Azerty, This should work: EXEC SQL DECLARE GLOBAL TEMPORARY TABLE your_table AS select a.champ1, ... | ||
| temporary table | 12/7/2009 | Melvin Davidson |
| Q: At this moment I am working on a project to optimize the database ingres 2006 [9.2.0] and ‘queries’ ... A: Azerty, I am not an expert on OpenRoad (it is a front end to Ingres), but most probably the ... | ||
| Ingres and LoadRunner | 7/24/2009 | Jean-Pierre Zuate |
| Q: Bonjour, Dans le cadre de test de charge et performance, je dois tester une application qui est ... A: Bonjour, Déjà pour commencer Ingres 3.0 est déjà une vieille version de Ingres. Préférez lui, si ... | ||
| connect to Ingres 6.4 db from Visual DBA 9.2 | 7/16/2009 | Jean-Pierre Zuate |
| Q: I am new to Ingres. We have a 6.4 database on another server that I would like to connect to from ... A: Welcome to Ingres world :) To connect to a remote Ingres database (any direction and any version ... | ||
| Ingres vs Oracle | 7/9/2009 | Jean-Pierre Zuate |
| Q: I am currently doing a thesis on Open Source in government. We use Ingres currently in our ... A: First of all, thank you to adress me your question. Unfortunaly, I can't provide any consistant ... | ||
| Ingress 1.2 | 6/22/2009 | Jean-Pierre Zuate |
| Q: From where I can download Ingress 7.3.3? A: you can download the latest version of Ingres here : http://esd.ingres.com/ You must have an ... | ||
| I would like to learn ingres v 2.6 | 5/13/2009 | Jean-Pierre Zuate |
| Q: As I would like to learn ingress v 2.6, i need some study materials and it would be great if you ... A: First of all, thousands of apology for the late of my reply. Ingres, Oracle, MySQL, Postgresql, ... | ||
| connecting powerbuilder with ingress 9.0 | 5/5/2009 | Melvin Davidson |
| Q: i have installed powerbuilder v 8.0 and ingress v 9.0 in my laptop which is running in win.vista ... A: This question is very similar to one that has already been answered in this forum. Basically you ... | ||
| E_GC2210_LCL_ABORT Session failure: Local ABORT condition. | 3/31/2009 | Jean-Pierre Zuate |
| Q: When our report runs after 90 minutes, we get this error. Not sure why. The application connects to ... A: First sorry to reply so late but I was in a place with a difficult web access (algeria). Often some ... | ||
| Ingres to Flat File | 3/26/2009 | Jean-Pierre Zuate |
| Q: Jean, I want to export an Ingres database or tables to an ascii file so I can load the file via ... A: First ensure you use the -c option in copydb to have ASCII data files (vs binary, not usable in ... | ||
| replication dans ingres 2006 | 3/14/2009 | Jean-Pierre Zuate |
| Q: Salut! Voila après la lecture de la doc, je veux implémenter le CDDS ci-joint. Ma question est : ... A: Bonjour, Je peux peut être vous aider à condition que je puisse vous envoyer un (vieux) document ... | ||
| ODBC pour INGRES 2006r2 | 3/12/2009 | Jean-Pierre Zuate |
| Q: bonjour, je me tourne vers sous, ayant déjà eu l'occasion de vous poser des questions et d'avoir eu ... A: Bonjour, En effet je me souviens des quelques questions en français issues de ce site ;-) Pour ma ... | ||
| Compare two tables/sql results from two different databases | 1/17/2009 | Jean-Pierre Zuate |
| Q: I'm newbie to Ingress and I've come across an interesting assignment in my company. I need to ... A: First, thank you for your interest about Ingres. Yes copydb can help you in this case. The table ... | ||
| Report Writer - Sums of Absolute Values | 12/15/2008 | Jean-Pierre Zuate |
| Q: Within the .FOOTER of an Ingres report, can I print the sum of absolute values of a numeric variable ... A: As far as I know I suppose you can have 2 sql functions in an expression for .PRINTLN but there are ... | ||
| Client - Server Connection Problems | 12/13/2008 | Jean-Pierre Zuate |
| Q: I have on my Windows XP Pro installed Ingres Client (Ingres2006-9.1.-103). I am trying to connect to ... A: When Ingres ask you for a password when you are using a vnode and you did not expect to give one, it ... | ||
| Report Writer - Sums of Absolute Values | 12/12/2008 | Jean-Pierre Zuate |
| Q: Within the .FOOTER of an Ingres report, can I print the sum of absolute values of a numeric variable ... A: The documentation say "yes you can", because I see examples like your's. Extract from documentation ... | ||
Jean-Pierre Zuate
Top Expert on this page
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) - Ingres 9.x, Ingres 10.x - 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
Education/Credentials
Computing bachelor (1989)
Past/Present Clients
More than 100 customers during my 6 years of CA has an Ingres consultant, all around France and Africa (Togo, Cameroon, Morrocco, ...)
©2012 About.com, a part of The New York Times Company. All rights reserved.