| Subject | Date Asked | Expert |
|
| 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 ...
|
| Unload problem with default sequence | 8/16/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: -) First please excuse for the late, but I'm on hollidays and Internet is not so accessible by this ...
|
| Ingres Procedure | 8/3/2007 | Jean-Pierre Zuate |
Q: I am new to Ingres and I am creating a complex stored procedure with calculation involve. The sample ...
A: First, welcome to the Ingres World :-) Yes you can have more than one SELECT/INSERT/UPDATE/DELETE ...
|
| Ingress Database upgrade | 7/19/2007 | Jean-Pierre Zuate |
Q: How complex is an Ingress upgrade from 2.0 to 2.6.
A: It depend on the database volume, age, state, how machine do you have, etc. etc. Usualy it is a ...
|
| Ingres database windows to linux | 6/22/2007 | Jean-Pierre Zuate |
Q: Can anyone provide the steps to transfer Ingres database from windows to linux (debian) and vice ...
A: The only way you have is to use Ingres/Replicator. The only need you have to replicate your data is ...
|
| Ingres database windows to linux | 6/21/2007 | Jean-Pierre Zuate |
Q: Can anyone provide the steps to transfer Ingres database from windows to linux (debian) and vice ...
A: To transfer Ingres data from any platform to any, you must take care of the following from both side ...
|
| node creation | 6/18/2007 | Jean-Pierre Zuate |
Q: Can you tell me the steps in order to create a node in windows. What option I need to choose?
A: To create a node in Windows you can either user netutil (from Dos command line) or the Ingres ...
|
| Connecting Ingres database for Powerbuilder application | 6/18/2007 | Jean-Pierre Zuate |
Q: I have installed ingres on Linux Red Hat.I have developed a powerbuilder application that has to ...
A: Next time try to reach me directly with Gmail : jpzuate@gmail.com :-) For putty you can try ...
|
| Connecting Ingres database for Powerbuilder application | 6/14/2007 | Jean-Pierre Zuate |
Q: I have installed ingres on Linux Red Hat.I have developed a powerbuilder application that has to ...
A: If I can help you ? Well I will try ;-) I suppose your database is on Linux Box and your .xls file ...
|
| Connecting Ingres database for Powerbuilder application | 6/11/2007 | Jean-Pierre Zuate |
Q: I have installed ingres on Linux Red Hat.I have developed a powerbuilder application that has to ...
A: To connect to Ingres thru a PC with Windows and Linux you can use one of the following : - native ...
|
| Ingres to flat files in unix | 6/2/2007 | Jean-Pierre Zuate |
Q: I am not aware about ingres other than knowing that it is an database, but as I want to get few ...
A: Of course you can interact via shell script with your data. For that, you must use the command line ...
|
| import data | 5/25/2007 | Jean-Pierre Zuate |
Q: I want to Import xml or mdb or sql database into my ingress database ; how i will do that ?
A: As far as I know the simpliest way is to import data via Ingres Import Assistant. You can find this ...
|
| need clarification on ingres | 5/17/2007 | Jean-Pierre Zuate |
Q: what is the equivalent datatype for "I4"(ingres) in sql server? and tell me is keymaint procedure is ...
A: > what is the equivalent datatype for "I4"(ingres) in sql server? I don't know, check the SQL Server ...
|
| Ingres 6.4 db export to flat file | 5/9/2007 | Jean-Pierre Zuate |
Q: How can I export ingrs 6.4 db to flat file with any delimiter ANSWER: Hello, You can use the SQL ...
A: All what you want is in the copy column format specification. Here is an extract from the SQL ...
|
| Ingres 6.4 db export to flat file | 5/7/2007 | Jean-Pierre Zuate |
Q: How can I export ingrs 6.4 db to flat file with any delimiter
A: You can use the SQL instruction "copy table ..." and/or use one of the following Ingres utility : ...
|
| Export Db and import into another db | 1/10/2007 | Jean-Pierre Zuate |
Q: I Jean, we would like to export data from node1:database and import into node2:db (same name) Can ...
A: Suppose your machines call A and B, A is the source one, B the destination 1/ connect to B 2/ ...
|
| returning error | 12/18/2006 | Jean-Pierre Zuate |
Q: Jean Pierre. I can't handle one error because errno neither dbmserror returns its code. The error ...
A: First of all, you can find help with error messages from two way : - in the directory II_SYSTEM ...
|
| unloadtable | 12/5/2006 | Jean-Pierre Zuate |
Q: I would read the deleted records of a tablefield in the order in which they were deleted. The ...
A: Yes I hope I can help you ... Let me remember some knowledge : 1/ _state = 4 if a row is deleted 2/ ...
|
| Ingres Vs oracle | 11/22/2006 | Jean-Pierre Zuate |
Q: How ingres is better than oracle?
A: First at all, let me present myself. I'm working with Ingres since 14 years now, first as a DBA on ...
|
| Ingres and Postgres | 8/10/2006 | Peter Gale |
Q: Peter, I have few questions. 1. What is the difference between Ingres and PostgreSQL? Is Ingres a ...
A: I have no knowledge of PostgreSQL other than the fact that it was developed from the original early ...
|
| how to subsite dynamic values in ingres plsql procedure | 8/7/2006 | Peter Gale |
Q: suppose for oracle i have a sql file which selets whether the employee with name peter is there or ...
A: Sorry for the delay in answering. Busy times. The key problem you have here is passing in parameter ...
|
| how to subsite dynamic values in ingres plsql procedure | 8/7/2006 | Peter Gale |
Q: suppose for oracle i have a sql file which selets whether the employee with name peter is there or ...
A: Windows batch file make this a little bit tricky as they dont suppport redirection too well. Ingres ...
|
| how to subsite dynamic values in ingres plsql procedure | 8/7/2006 | Peter Gale |
Q: ai i have one small problem like i have to execute a query where the query is placed in a .sql file ...
A: Can you supply a more extended example of what you are trying to do please. Ingres uses database ...
|
| ingres string for 1.2 version | 8/1/2006 | Jean-Pierre Zuate |
Q: We are using ingres 1.2 version on sco-unix platform no swap machine. Our current string will be ...
A: First receive my apologies for the time I take to answer your question. I was on holliday for 2 ...
|
| data exporting from ingres | 6/12/2006 | Jean-Pierre Zuate |
Q: How do i export data to flat file or spreadsheet from ingres visual dba gui
A: For Ingres R3 and following. From Ingres Visual Manager try to right-click and choose Ingres Export ...
|
| Please see below | 6/9/2006 | Jean-Pierre Zuate |
Q: REQUEST FOR QUOTATION (RFQ) – OPENROAD DEVELOPER (June 2006) The purpose of this request is to ...
A: I'am actualy leaving CA France to act as a freelance. I've already done many Openroad dev and ...
|
| isql keyboard command | 2/13/2006 | Jean-Pierre Zuate |
Q: I am looking for a list of isql keyboard commands. I have some of the commands, but wonder if there ...
A: I can't find in the documentation where are those command, and I remember there are explained here ...
|
| update with variables | 1/26/2006 | Jean-Pierre Zuate |
Q: I'm writing an UPDATE statement where I must include the name of the column which I want to update ...
A: I suppose your SQL is in a C programm (embeded SQL) or ABF. If you look in the R3 doc PDF files and ...
|
