| Subject | Date Asked |
|
| conncet database | 8/14/2008 |
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 |
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 |
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 ...
|
| Padding the output from copy statement | 6/6/2008 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 string for 1.2 version | 8/1/2006 |
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 |
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 |
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 |
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 |
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 ...
|
| Developing Tools For Ingres Reoprt writer | 1/9/2006 |
Q: I want to know , whether there is any Report developing tools in Ingres Database . I want any ...
A: Sorry to be so late. Yes you can use RBF (Report By Form) to make your reports ReportWriter but in a ...
|
| How to extract data from Ingres DB to Oracle DB | 12/19/2005 |
Q: I dont know much about ingres, but i would like to tranfer the entire data in ingres to Oracle. If ...
A: First sorry to be so late, but I just recover some lost mail access. Well I really don't know how ...
|
| Crystal Report CrossTab | 11/12/2005 |
Q: I have question about Crystal Report CrossTab. When I use a new formula in crosstab report it ...
A: First sorry to be so late in my answer but I loose some mail access in a short past. Crystal report ...
|
| repetead select | 10/4/2005 |
Q: bonjour, puisque nous sommes entre français, alors parlons français, ce sera plus simple ! donc, ...
A: Bonjour, Faire un lien entre la répétition des "define query" et les locks, j'ai un peu de mal à ...
|
| repetead select | 9/28/2005 |
Q: to improve the performances of applications, i use 'repeated select' in my programs. when the ...
A: First, sorry to answer a little in late ... "repeated select" only tell to the dbms to store the ...
|
| Connecting using dotnet | 9/7/2005 |
Q: . Sorry to be a pain but you've been so helpful and I dont know who else to ask. I have created the ...
A: Well, you're right, I'am not a .NET speaker :-) Just a remark if it can help : The message you are ...
|
| Connecting using dotnet | 9/6/2005 |
Q: I am still confused about this ingres. How can I create a simple database connection between user ...
A: First, I suppose Ingres/NET is installed and started on your client machine (you can see two ...
|
| Connecting using dotnet | 9/5/2005 |
Q: I have installed ingres. I have created the user tester and have created my database under this ...
A: First, you must distinct 2 way of working with users : os mode and Ingres mode. In Ingres world, ...
|
| dropping system | 4/7/2005 |
Q: The local DBA says that a very large query can "drop the system" (stop one or several ingres ...
A: Yes your DBA is right. A product as Ingres (or Oracle, or so on) is a very complex product. Many ...
|
| data base | 3/11/2005 |
Q: My company is a manufacturing company and currently is running the computer system which is known as ...
A: An ERP is an application (collection of programs) that store data in a database (Ingres, Oracle, ...
|
| 10 tables query 2 | 3/3/2005 |
Q: I've seen that for queries with less than nine tables involved in, the QEP begins with this ...
A: OK, I see :-) In Ingres the optimizer look the amount of time it spend to build the QEP vs the ...
|
| 10 tables query 2 | 3/2/2005 |
Q: Bon jour, Jean-Pierre, Sorry, I don't understand the 'correct indices' part. Could you explain it a ...
A: Correct indices ... When you access data through a SGBD/R, you "only" do join between columns. If ...
|
| 10 tables query | 2/28/2005 |
Q: Have you any idea about how to improve the performance of a ten tables based query (with k-joins)?
A: Your question is in FoxPro folder, and I'am an Ingres expert. Hope this question is for Ingres ... ...
|
