Stack Overflow
Stack Overflow

Questions tagged [actian]

Use for questions related to Actian Corporation tools including Actian Vector Analytics Database, Actian NoSQL Object Database, Actian Zen Embedded Database, Actian X Hybrid OLTP and Analytic Database, Actian OpenRoad 4GL RAD, Actian DataConnect, Actian DataCloud, Developer Tools, etc.

Ingres Database is now known as Actian X Hybrid Analytics Database, and combines Ingres OLTP with the X100 table and Vector engines for operational analytics.

Pervasive PSQL Database is now known as Actian Zen Embedded Database and now also includes support for IOT.

Vectorwise is now known as Actian Vector Analytics Database.

Versant Object Database is now known as Actian NoSQL Object Database.

27 questions
0
votes
0 answers

How to create DSN in Ingres using Ubuntu?

I got the message error below when i try to test the DSN. I verified the Path of the driver I verified the permission of the driver Could someone know what mean this error or any Ideas for the solution?
JOSE0219
  • 9
  • 5
0
votes
1 answer

date difference in minutes for Ingres

I have DB (ingres 11) which works with ANSI i need to findout difference in minutes between dates, I have statement SELECT top 10 date('now') - '06.07.2017 10:20:02' itscalculating and returning me this 186 days 22 hrs 43 mins how i can…
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
0 answers

connect to ingres database from windows

How do I connect to a Ingres DB using SQuirrel SQL Client. I am getting the following exception java.sql.SQLException: Unable to create connection. Check your URL. at…
user3671807
  • 33
  • 1
  • 4
0
votes
1 answer

Pervasive v11: Remove optional paramter in where clause

I am using Pervasive V11. In the following query i have an optional parameter called ModelYear. I would like to exclude it from running in the WHERE clause when it is passed as NULL. SELECT Year,Make,Style,Model,Color1,VIN …
user7822440
  • 15
  • 7
0
votes
1 answer

Extracting PO box from an address

I have a column that looks like this Column 1 -------------- 123 Main Street P.O. Box 1234 PO Box 4569 P.O Box 4975 P.O. Box 796 Attn: Lease How do I only extract the numbers so it's only 1234, 4569, 4975, 796? (Various different PO to…
tryingtolearn
  • 51
  • 6
0
votes
1 answer

How to find number of tables in a database and size of database Pervasive

I am using Pervasive Control Center v11. How do I find the size of an entire database and the number of tables? The following results in error:'error in expression' SELECT pg_size_pretty( pg_database_size('RECORDS'))
user7822440
  • 15
  • 7
0
votes
1 answer

Convert vbscript into rapid integration flowlanguage

I'm using Pervasive 9.2 and would like to somehow convert the vbscript into pervasives RIFL language. I want to execute the code during a Process where the f(x) component is executed to run the code. As far as the Path to the xml data, I'll be using…
Fabe Dole
  • 31
  • 1
  • 1
  • 7
0
votes
1 answer

Visual Studio 2015 project that references both EF 5 and EF 6 projects

Can anybody tell me if there is a way to have a project that references both Entity Frameworks 5.x and 6.x? I have two separate data projects and one has to be EF 5.x, it's Actian Pervasive and they don't support EF 6.x. The other is a MS SQL…
dblwizard
  • 595
  • 7
  • 26
0
votes
1 answer

Check if fields in a column are dates and convert them

I am creating a process that will eventually get data from one place and place it into another. For this to happen, I need to transform my data. I have a column that contains string's and dates timestamp 20POST /xxxei/adsa/ContentVis HTTP/1.1 …
Will
  • 49
  • 6
0
votes
1 answer

Table properties using SQL in Pervasive SQL control centre

I wanted to retrieve table properties using pervasive sql control center. Version 9.52 How can i retrieve all the tables properties from a Database ? i tried some thing like below for one table but it throwed me an error select * from "TABLE…
mikey
  • 37
  • 8
0
votes
1 answer

How to split a string in ANSI-SQL

How can I split a column value in ANSI SQL? I use VectorWise DB and VW doesn't support split method. How can I solve it? SELECT stars, LEFT(stars, POSITION(',', stars + ',') - 1) AS star1, CASE WHEN CHARACTER_LENGTH(oyuncu) -…
Tayfur Yılmaz
  • 21
  • 1
  • 11
-1
votes
1 answer

Get Max Insert Dates in SQL with JOINS

I have a list of tables: select tableList from information_schema.tables Each of these tables have an insert date. I want to get the max(insertdate) of each of these tables, and place the insert date right next to it, like: Column1 Column2 table1…
Will
  • 49
  • 6
1
2