| Subject | Date Asked | Expert |
|
| 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 ...
|
| Ingres Star | 12/5/2008 | Jean-Pierre Zuate |
Q: We are migrating from Ingres II to Ingres 2006 from single production to multiple databases with a ...
A: First, sorry for my late reply. I'am not a full expert on Ingres/Star and I could not help you ...
|
| Ingres Star | 12/4/2008 | Jean-Pierre Zuate |
Q: We are migrating from Ingres II to Ingres 2006 from single production to multiple databases with a ...
A: Unfortunaly I have no particular advice except breaking your concept (and I know it is not ...
|
| Oracle on Unix Platform | 11/25/2008 | Jean-Pierre Zuate |
Q: Sir/Madam I have huge database. In that I have a table 'RPLI_DET' columns 'POLICY_NO' and ...
A: I don't know if Oracle have particular functions to do that (remember I'm an Ingres expert not an ...
|
| Convert Ingres data to DB2 | 11/20/2008 | Jean-Pierre Zuate |
Q: We are migrating from an HP UX system with Ingres 2.1 database to an iSeries with DB2. We need to ...
A: To migrate data from an ingres installation to an other or from ingres to something else you can use ...
|
| negative value int within ingres stored proc | 11/6/2008 | Jean-Pierre Zuate |
Q: Is there a way to convert a positive value int to a negative value int within a stored procedure? ...
A: First sorry for this late reply. Each time i receive a question from this site I'am far from home ...
|
| select union dans procedure stockee | 9/30/2008 | Jean-Pierre Zuate |
Q: botoujours en voulant écrire des procédures stockées dans une base ingres, j'ai des soucis pour ...
A: re bonjour, Je vous passe les excuses sur la lenteur de ma réponse, je les ai déjà présentées il y ...
|
| ingres procedures | 9/30/2008 | Jean-Pierre Zuate |
Q: bonjour, j'utilise des procédures sql dans une base ingres pour des traitements assez complexes. je ...
A: Bonjour, Tout d'abord désolé d'avoir un peu trainé pour la réponse, j'étais à l'étranger et j'ai eu ...
|
| Ingres vs. Others | 9/29/2008 | Jean-Pierre Zuate |
Q: I want to use Ingres for my startup and want to integrate it with .NET 2.0. I want to know how the ...
A: Has I say in my previous post, Ingres is not a pure community product. Why Ingres is jumping from ...
|
| Ingres vs. Others | 9/28/2008 | Jean-Pierre Zuate |
Q: I want to use Ingres for my startup and want to integrate it with .NET 2.0. I want to know how the ...
A: Short question, big answer needed. Sorry but mine will be short ;-) First, you must compare the ...
|
| Ingres vs. Others | 9/27/2008 | Melvin Davidson |
Q: I want to use Ingres for my startup and want to integrate it with .NET 2.0. I want to know how the ...
A: >I want to use Ingres for my startup and want to integrate it with >.NET 2.0. I want to know how the ...
|
| Ingres vs. Others | 9/27/2008 | Jean-Pierre Zuate |
Q: I want to use Ingres for my startup and want to integrate it with .NET 2.0. I want to know how the ...
A: Normaly it works. Please have a look at Ingres official documentation here : ...
|
| Ingres descriptor block | 9/12/2008 | Jean-Pierre Zuate |
Q: I'm back again. I am bothered with this Ingres error message that sometimes halt our operation. ...
A: Nice to read you again :-) It seems your RDF resources are exhausted (RDF stand for Relational ...
|
| OpenROAD Default Database connection | 8/26/2008 | Jean-Pierre Zuate |
Q: bonjour j'ai posé ma question le 13/08/2008 ais tu ma pas compris ma question est simple : je ...
A: Bonjour, Désolé mais je n'ai pas ton email ... En ce qui concerne la base par défaut d'openroad ...
|
| conncet database | 8/14/2008 | Jean-Pierre Zuate |
Q: i would an example who connect at different database for extracte data and save it in my base as ...
A: Excuse me but your question need complement to be answered. - How do you want to connect to your DB ...
|
| connecté plusier Base ;extraire des donné a distant | 8/13/2008 | Jean-Pierre Zuate |
Q: SVP j'ai utilisé la command direct Conncet avec tous sa syntaxe j'ai compilé pas d'erreur ,mais sa ...
A: Bonjour, J'ai cherché sur Google Direct Connect et je ne vois pas bien le rapport avec Ingres ni ...
|
| démarrage ingres | 7/24/2008 | Jean-Pierre Zuate |
Q: Nous faisons tourner ingres sur un serveur unix. ingres est 'tombé' tout d'un coup en voulant le ...
A: Bonjour, A priori il faut reformater le log file. Si vous cherchez dans les astuces des articles ...
|
| SQL in Ingres program | 6/17/2008 | Melvin Davidson |
Q: I have a form in openroad that is basically a list of check boxes that correspond to database ...
A: Laurence, The error that occurs is: E_US0F06 line 1, Syntax error on 'FROM'. The correct syntax ...
|
| Padding the output from copy statement | 6/6/2008 | Jean-Pierre Zuate |
Q: Jean-Pierre, You recently told me how to pad the output from a copy table statement. I cannot get ...
A: Considering your code : 'XB':{ vstring = 'DECLARE GLOBAL TEMPORARY TABLE SESSION.temp ' + ...
|
| importaion DB Ingres 2006 | 5/19/2008 | Jean-Pierre Zuate |
Q: bonjour dans l'entreprise où je travail je travail sous une BD Ingres 2006, qui je veux l'exporter ...
A: Comment repérer les noms des utilisateurs possédant des objets ? 1/ La méthode "fine" Dans le ...
|
| importaion DB Ingres 2006 | 5/9/2008 | Jean-Pierre Zuate |
Q: bonjour dans l'entreprise où je travail je travail sous une BD Ingres 2006, qui je veux l'exporter ...
A: Bonjour, Désolé du retard, mais je étais temporairement dans une zone sans internet ... Les ...
|
| importaion DB Ingres 2006 | 5/6/2008 | Jean-Pierre Zuate |
Q: bonjour dans l'entreprise où je travail je travail sous une BD Ingres 2006, qui je veux l'exporter ...
A: Bonjour, reload.bat peut être aussi lancé sous DOS (Démarrer / Exécuter / cmd) et ainsi vous verrez ...
|
| import *.mdb files to ingres in Linux | 2/26/2008 | Jean-Pierre Zuate |
Q: I am new to Ingres and I am just installing ingres2006-9.0.4-104-NPTL-gpl-pc-linux-i386.tgz in ...
A: You do not have to execute the file version.rel. This file contain the version of Ingres (a ...
|
| export table data from ingres to .csv or .txt file | 2/13/2008 | Jean-Pierre Zuate |
Q: In the company I'm working for, we're using an openroad application that run on a Ingres 2.6 ...
A: Bonjour, Vous pouvez utiliser l'instruction SQL copy table (cf http://docs.ingres.com/sqlref/Copy) ...
|
| Error in update | 1/31/2008 | Jean-Pierre Zuate |
Q: I have a present problem which i cannot solve. I have a simple update command but will generate ...
A: This error is well knowed since Ingres 5.* and is part of a "familly" of sames error saying : - ...
|
| Ingres Upgrade from 6.4 to 2006 | 1/13/2008 | Jean-Pierre Zuate |
Q: Can you let me know, what are the critical things, I need to look before moving the data and scripts ...
A: From Ingres 6.4 to a newer version there is a documentation, it's call the Migration Guide. Here is ...
|
| Copy Ingres Intallation | 12/11/2007 | Jean-Pierre Zuate |
Q: Is it possible to copy an Ingres intallation from one pc to another?. Let say, I have an Ingres ...
A: It is not a good idea at all to unload/reload iidbdb. You must start from an empty Ingres ...
|
| IP address change of Unix server | 11/29/2007 | Jean-Pierre Zuate |
Q: We are customer of ingres using Ingres V2.0 in 2 diff unix machines. 1). On Alpha 800 Server with ...
A: First, my apologies for the late ... Concerning network adddress Ingres is impacted by the machine ...
|
| ingres down | 9/21/2007 | Jean-Pierre Zuate |
Q: Zuate i have installed ca scm with ingres on my windows 2003 sp2 storage server since the begining ...
A: No comment about the CA support response (for Ingres replacement). When you said "replace it with ...
|
| ingres data sharing | 8/29/2007 | Jean-Pierre Zuate |
Q: I have a procedure that fires a rule if DatabaseA.TableA has row inserted based on certain criteria. ...
A: What you need is to replicate your INSERT (UPDATE or DELETE) from DatabaseA to DatabaseB. All depend ...
|
| Unload problem with default sequence | 8/21/2007 | Jean-Pierre Zuate |
Q: Good Day! I have this sequence and a table that has a PK default to a sequence.nextval. But when i ...
A: Perhap's turning the cache off will degrade performance but sequence will be always faster than the ...
|
