Stack Overflow
Stack Overflow

Questions tagged [ingres]

Use this tag for Ingres / Actian X questions. The Ingres v11 RDBMS is now known as Actian X and in addition to supporting OLTP, also supports analytic workloads with X100 tables and Vector engine, making it a hybrid OLTP and analytic database.

The Ingres 11 RDBMS is now known as Actian X and in addition to supporting OLTP, also supports analytic workloads with X100 tables and Vector engine, making it a hybrid OLTP and analytic database.

Actian X combines a record breaking analytic engine with rock solid OLTP to enable enterprise applications with both OLTP and analytic features. The X100 component, from Actian’s Vector analytic database, lets you store Ingres and/or external data in X100 tables, which are processed using the specialized X100 engine, allowing faster performance for analytical database tasks. OLTP and analytic workloads can be run together and the queries and access methods you’re already using can also be run against the X100 data.

Ingres v11 / Actian X product documentation is available here.

Ingres / Actian X customer support forum is here.

149 questions
0
votes
3 answers

ingres sql join 2 rows into 1 row from 1 table using case

Please accept my apologies if this has been asked in the past but I have been through the questions and can't find the answer. I have a table with multiple entries as follows: key | type | Code | Date 1234 | S | 10DY |…
user2928556
  • 3
  • 3
0
votes
2 answers

SQL , INGRES : replace by blank after some char

days: char (31) period : char (31) days : 1234567891234567891234567891234 period: AAAAAAAAAABBBBBBBBBBCCCCCCCCCCD I want to replace everything by * after the 20th character days :…
Thulasi
  • 29
  • 3
0
votes
2 answers

Make a column nullable in Ingres

I would like to make a column nullable in Ingres Database, but I couldn't find the statement, or any tool that allow me to do this. Anyone can help me? Ingres Version: 9.2.1
Lucas Do Amaral
  • 137
  • 2
  • 11
0
votes
1 answer

openRoad stored procedure output parameter

I'm a newbie in Ingres and OpenRoad. Is it possible to have a database stored procedure return two values? I want to return an integer and a varchar to use in multiple OpenRoad frames. I can create the stored procedure but the parameter does not…
DjSol
  • 208
  • 1
  • 11
0
votes
1 answer

E_VW1035 Cannot connect to Vectorwise server

I started with vectorwise, i try to create database but i can do this. ingres@xx:~$ createdb essai I have an error : Creating database 'essai'. . . E_VW1035 Cannot connect to Vectorwise server. (Mon Jun 17 09:01:01 2013) Creation of database…
chicchoc88
  • 61
  • 1
  • 4
0
votes
2 answers

Spring - Ingres RDBMS support in sql-error-codes.xml error code mapping file

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…
Adrian
  • 5,571
  • 9
  • 41
  • 68
-1
votes
2 answers

sql show date time as dd/mm/yy hh:mm:ss without using CONVERT(VARCHAR(10)

I am using Ingres Db which is old and cant do much, I need to show datetime in specific format as dd-mm-yyyy hh:mm:ss DB retunrn me it as 01.02.2018 14:43:53 it is NOT SQL server so I CANNOT use CONVERT(VARCHAR(10) Is there a way to…
Andrey
  • 1,331
  • 10
  • 29
  • 57
-1
votes
1 answer

SQL Query getting multple results from 3 table inner join

I am running an sql query (using microsoft report builder)joining three tables and getting duplicates, i cant seem to stop this. i have one table (tableA) that holds the relevant fields ownerID, propertyID, vacationDate. I want to find the name of…
Larry
  • 3
  • 2
-1
votes
1 answer

Long varchar into varchar Ingres DB

I have INGRES DB 10.0 I have variable with LONG VARCHSR data type. in which users submit long string, then i have while loop which taking +2000 characters from this string and put it in table where column has varchar (255) data type. when i am…
Andrey
  • 1,331
  • 10
  • 29
  • 57
-1
votes
1 answer

Genexus and Ingres DBMS

We're Actian Corp. partner reseller and have a customer that use Ingres DBMS for years. Now, they want to integrate Genexus developer environment with data store on an Ingres database. I was researching about data stores support for Genexus but…
Ocarles
  • 1
-1
votes
1 answer

Cannot Alter Column in Squirell SQL Client

I am trying to alter a column in my ingres DB to expand the size of the column. The query i'm running is ALTER TABLE test_table ALTER COLUMN address varchar(100) NOT NULL Which gives error Error: ALTER TABLE: invalid change of attributes on an…
gio10245
  • 17
  • 2
  • 10
-1
votes
1 answer

Which Linux platfrom required for Installation of ingres database version 9.2 and openROAD version 4.0

Hi I need to install ingres database version 9.2 and openROAD version 4.0. on a linux based system. Please provide me reference site or instructions to install. Thanks
lk121
  • 1,083
  • 2
  • 10
  • 10
-2
votes
1 answer

SIMILAR TO predicate ingres 4gl issue

I used this query to get a regular expression with successful results. select * from paso_string where 'AAAAAAAAA' SIMILAR TO columname But, When I use this query into ingres 4GL show me an error when I try to compiling and show me the follow…
JOSE0219
  • 9
  • 5
-2
votes
2 answers

how to retrieve sql column includes special characters and alphabets

How to retrieve a column containing special characters including alphabets in SQL Query. i have a column like this 'abc%def'. i want to retrieve '%' based columns from that table. Please help me in this regard.
user3636241
  • 1
  • 1
1 2 3
…
9
10