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
2
votes
1 answer

Pervasive SQL order by with if

In Pervasive SQL 11 I could use a IF statement in the ORDER BY: SELECT * FROM ( SELECT D1001 as 'part_number', '' as 'required_date', '' as 'confirmed_date' FROM PULAGER WHERE D1001 LIKE '1121%' UNION …
Conny Olsson
  • 1,567
  • 2
  • 11
  • 19
2
votes
1 answer

I have old .DTA Files and .DDF Files... now what?

First time poster here, so be gentle... I am completely stuck, I have been given the task of importing some old .DTA files into tables in SSMS so we can run queries off of them. Being brand new to .dta formats, I did some digging and this is the…
MichelleSQL
  • 21
  • 2
1
vote
0 answers

Precision error when using OPENQUERY and Global Shop Solutions/Actian backend

I am querying Global Shop Solutions (backend is Actian) and I'm using OPENQUERY to perform an aggregate operation and then pull those records into SQL Server 2019. When I run the code below, I get this error: Msg 7354, Level 16, State 1, Line…
TheMortiestMorty
  • 421
  • 2
  • 4
  • 12
1
vote
1 answer

Unlock a table of a ingres database

I have the problem that I runned an sql statement but haven't comitted it. Now the table is locked and I don't know how to unlock an Ingres database table. I have searched for some information but I can't find anything. Can anyone help me? Thanks in…
dankoe
  • 51
  • 1
  • 7
1
vote
2 answers

What am I doing wrong in this select query with left join and filters?

With Actian PSQL v13: I'm attempting to join two tables and filter the result set by a few criteria. One table is customer sales history. The other table associates customers to buying groups. Not all customers are in a buying group, so I'm doing a…
AJK
  • 67
  • 1
  • 2
  • 7
1
vote
1 answer

Substring an address using PSQL

I have a list of addresses in a column: Address Tampa, FL. 33620 Zephyrhills, FL. 33539 (1,000 lines) Is there a way to separate the city, state, and zip? I tried split_part but the function doesn't seem to work? I really need help on this! I am…
tryingtolearn
  • 51
  • 6
0
votes
1 answer

Actian PSQL/Pervasive SQL: unhex

i have some hex data in db. so i need to unhex it. something like: unhex('414243'). is there any functions or tricks to do it? i saw unhex function in actian ingres db.
Poly Deus
  • 1
  • 1
0
votes
1 answer

How can I filter my data down to a given Year or Month in a PSQL v13 Database

I get a syntax error in PSQL Control Center on an Actian 13 database when using Date_Part and I'm out of ideas on how to proceed. There are two fields in the table I am querying 'Date' and 'CreateDate'. I get the same error when I involve either…
Mark Holbert
  • 1
0
votes
0 answers

Actian/Pervasive PSQL Zen 13.30 error 46 random ocurrences

We currently use Actian PSQL Database in our core business application for more than 10 years. In the las few days, users actions using the application, randomly trigger error 46, which is related with "permissions issues", but what really happens…
Jorge S
  • 1
0
votes
1 answer

How to get a list of dates in Pervasive SQL

Our time & attendance database is a Pervasive/Actian Zen database. What I'm trying to do is create a query that just lists the next 14 days from today. I'll then cross apply this list of dates with employee records so that in effect I have a list of…
David
  • 59
  • 1
  • 7
0
votes
1 answer

Actian/Pervasive SQL and Date Variables

How are date variables declared and used in Actian Zen/Pervasive ? How do i fix this CREATE proc test1 () returns(TranDate integer, GLAcntNumber integer , Net decimal(39,19)) as BEGIN DECLARE :StartDate DATE ; SELECT CAST('2021-01-01' AS…
Habib
  • 70
  • 7
0
votes
1 answer

Does Actian PSQL 13.31 (Zen) have the equivalent of SQL Server "IN" in WHERE clause?

I have read a ton of Actian PSQL docs but cannot find out how to duplicate this simple SQL verb: SELECT column_name(s) FROM table_name WHERE column_name IN (value1, value2, ...); Does Actian PSQL 13.31 have the equivalent of SQL Server IN in the…
Keith Rowe
  • 1
  • 2
0
votes
1 answer

Remove spaces from right and left (TRIM) all selected columns

I have went through some documentations and as it states SELECT TRIM('') FROM something; can be used to trim strings. I have SQL command to get the table: "select NRO,SNAME,NAMEA,NAMEB,ADDRESS,POSTS,POSTN,POSTTP,COMPANY,COUNTRY,BID from COMPANY…
10101
  • 2,232
  • 3
  • 26
  • 66
0
votes
2 answers

Insert pandas dataframe into actian PSQL database table using python

I want to import data of file "save.csv" into my actian PSQL database table "new_table" but i got error ProgrammingError: ('42000', "[42000] [PSQL][ODBC Client Interface][LNA][PSQL][SQL Engine]Syntax Error: INSERT INTO 'new_table'<< ??? >>…
Priyanka Sonawane
  • 1
  • 2
0
votes
1 answer

How do I load a csv file into actian table?

The "copy" command is successful, but junk data is loaded into the table. "vwload" command errors out with a message "No table name specified". How do I load a csv file into actian table? * COPY TABLE airport2 () FROM '/tmp/head.csv' \g * select *…
shantanuo
  • 31,689
  • 78
  • 245
  • 403
1
2