In Oracle you can limit the number of rows returned in an arbitrary query by filtering on the "virtual" rownum column. e.g. select * from all_tables where rownum <= 10 will return at most 10 rows. Is there a simple generic way to do something similar in Ingres? ...
I want to know if there is a way to select a subsequent bunch of rows in select query in Ingres. For example, the first 500 rows can be selected by using the select first 500 from tablename, but if I want to select rows 501 to 1000, is there any way to do that? ...
Hey all, I have a .net 2.0 app being hosted on IIS, that connects to a Ingres DB. The connection uses iBatis with an ODBC driver to connect to an ingres database being protected behind an installation password. For some reason, when I'm debugging my code, everything runs fine. It establishes the connection without any problems. However...
I need to connect to an Ingres supplied demodb through OpenAPI, both Ingres and C application running on windows. What i have done: Created a "node" in the Ingres Network Utility named "usernode". created user accounts in the Ingres installation (named "user" password "user") and in the Windows user management (the same creds.) Granted...
Hi, I found EXPLAIN SELECT query very useful in MySQL because it gives information on how SQL will be executed and gives the opportunity to analyze, for e.g., missing indexes you should add in order to improve response BEFORE doing the query itself and analyzing stats. My question is: In databases like MS Sql, Firebird, Ingres, is ther...
Many (most? nearly all?) SQL dialects have a way to perform this type of function: date_add( MyDate, MyInterval ) I've been through all of the docs, but I cannot find this functionality in Ingres. My immediate goal is to get "MyDate plus 3 months". Does anyone know if there is a simple way to do this that I'm missing? Note: I realize t...
I have a Java project connecting to an Ingres database and using the Spring Framework. This issue is related to the error codes list configuration. According to Spring Framework API: Class SQLErrorCodes: JavaBean for holding JDBC error codes for a particular database. Instances of this class are normally loaded through a bea...
Hi All, I have a classic ASP application which is connecting to Ingres 9.3 database. The classic ASP website in IIS has windows integrated security enabled. It connects to Ingres for reading data, and its passing logged in user name and password to ingres for connection. We cant give read access to all the users, so I need some way of i...
I'm trying to create an SSIS 2008 Data Source View that reads from an Ingres database via the ODBC driver for Ingres. I've downloaded the Ingres 10 Community Edition to get the ODBC driver, installed it, set up the data access server and a DSN on the server running SSIS. If I connect to the SQL Server 2008 Database Engine on the server ...