Stack Overflow
Stack Overflow

Questions tagged [multivalue-database]

MultiValue is a type of NoSQL and multidimensional database, typically considered synonymous with PICK, a database originally developed as the Pick operating system. Current prominent varieties of the MultiValue Database include jBASE, UniVerse, UniData, Reality and D3.

37 questions
2
votes
2 answers

Unidata - Extract Count of strings from MultiValued fields

I'm a bit of a newbie when it comes to Unidata. My problem is this; I have lots of records with 20 fields. I want to extract a TOTAL count of the different values used in 1 of those fields; the field in question is multi-valued, so the data looks…
Jack McCauley
  • 43
  • 1
  • 9
2
votes
6 answers

Connect to Pick Database using Odbc C# .Net

How to Connect to PickBasic database using Ole db driver .. I need it badly help me out
Badmate
2
votes
4 answers

How do I find the column listing in UniVerse with RetrieVe or SQL?

I've got an issue where a table (file) is set up to return column foo on LIST table and SELECT * FROM table. I need to know the other possible columns in table. I'm pretty sure this was achieved by setting @ (behavoir definition of unqualified…
Evan Carroll
  • 78,363
  • 46
  • 261
  • 468
2
votes
2 answers

Pick and RDF/SPARQL

Anyone have any interest in intergrating RDF and/or SPARQL with a PICK database? Has anyone tried this yet? I have some thoughts about what to try. One idea is to figure out how to create a file with a dictionary that defines some correlatives that…
Fenugreek Femtosecond
  • 382
  • 2
  • 8
1
vote
1 answer

How to return exit code in UniData?

Is there a way to return an exit code to the operating system in UniBasic or ECL ? For example I want to capture a user-programmable exit code that can be retrieved with Bash's $? variable. From what I see, the UniBasic STOP and ABORT commands only…
mvanle
  • 1,847
  • 23
  • 19
1
vote
1 answer

Managing jBASE triggers

I have reviewed the jBASE documentation on triggers but I have some additional questions on managing them. Does a trigger use up a license seat? If so, continuously, or only upon action? Does a trigger continue running in the background like a…
Rich Brim
  • 59
  • 6
1
vote
1 answer

MySQL procedure to load data from staging table to other tables. Need to split up multivalue field in the process

I'm trying to export data from a multivalue database (Unidata) into MySQL. Lets say my source data was a person's ID number, their first name and all the states they've lived in. The states field is a multi value field and I'm exporting them so that…
David
  • 193
  • 2
  • 3
  • 10
1
vote
2 answers

MV.NET calls much slower when website accessed remotely vs locally

I have an asp.net webforms page that makes calls to pick/d3 through mv.net. I've logged the server side performance by surrounding the mv.net calls with timing code, for example: logTimeElapsed() getDataFromPick() 'gets 5 rows of test…
Jim B
  • 420
  • 3
  • 10
1
vote
2 answers

Multi-valued Database (UniVerse) -- SM (MV) vs SM (VS) and ASSOC()

I have a question taken from pg 16 of IBM's Nested Relational Database White Paper, I'm confused why in the below CREATE command they use MV/MS/MS rather than MV/MV/MS, when both ORDER_#, and PART_# are one-to-many relationships.. I don't understand…
Evan Carroll
  • 78,363
  • 46
  • 261
  • 468
1
vote
1 answer

Can't get UniObjects COM Object to load with PHP in Windows 2008 R2

I am trying to use COM function in PHP but I am not sure what am I doing wrong. This is my first line in PHP script $UOSession = new COM("UniObjects.Unioiafctrl") or die("Cant instantiate UO"); I did use regsvr32 to register uniobjects.dll and it…
zuboje
  • 696
  • 3
  • 11
  • 28
1
vote
3 answers

Creating a browser front-end for TigerLogic D3 DB application

I have an interesting conundrum. I have been challenged with identifying the most suitable process in which to create a "browser front-end" to an existing multi-user application built within the TigerLogic/Pick D3 environment. My research indicates…
user1682651
  • 31
  • 4
1
vote
1 answer

Maximum virtual attribute size in Unidata

I am receiving the following error when trying to retrieve data using a largish virtual attribute: Virtual Attribute Error: Virtual field too big. I have been unable to locate the maximum size allowed for a virtual attribute in the Unidata manuals.…
Jimi DeRouen
  • 11
  • 1
1
vote
1 answer

D3 Connection issue using mvsp java api

I am trying to connect to D3 Database with MVSP java api. So far: I have downloaded the mvapi.jar added it in project lib folder written the sample code for connection inside main method String url = "jdbc:mv:d3:hostname:portNo"; Properties props…
Vivek Singh
  • 11
  • 2
0
votes
2 answers

ADO adDate field returns "12:00 am" when it's value is Null

We are working on a project that generates a report using ActiveReports 2(COM for VB6), the data is coming from an ADO Recordset that we created manually(we are using a MultiValue Database that doesn't return Recordsets). If I set the data field is…
NeerPatel
  • 863
  • 6
  • 19
0
votes
1 answer

Selecting all values from multivalued field in Oracle c11 - SQL query

I am trying to select all the values from multivalued data column. Values are separated with ý. This query I wrote does exactly what I intended, but unfortunately I am working on 11g so I can't use CROSS APPLY. Any suggestions how to go around CROSS…
StanTheThey
  • 1
  • 1
1
2
3