Questions tagged [pick]

Pick is an alternate name for all MultiValue DBMS platforms. Examples include D3, jBase, Unidata, Universe, QM, and Reality. The name Pick is from the originator Richard Pick. The platform has been in worldwide use since the 1960's and continues today as a NoSQL alternative to RDBMS for all modern business needs. One can argue that this is the real first NoSQL database as it has been used since the 1960's.

The Pick system is one of the first DBMS systems to be developed and used on a commercial scale. It predates most other systems and its first commercial use was as the Generalized Information Retrieval Language System (GIRLS) on an IBM System/360 in 1965 by Don Nelson and Dick Pick at TRW for use by the U.S. Army to control the inventory of Cheyenne helicopter parts.

The Pick database management system is also referred to as MultiValue, MultiDimensional, and even MultiRelational. This alternative DBMS to SQL/RDBMS offers enterprise-level scalability and flexibility to support dynamic growth while being equally at home in single user and hobby applications.

While it's easy to create databases, schema, and programs in this environment, its structure allows for complex definitions of data structures and program logic to support Banks, Hospitals, ERP, Insurance, Manufacturing, and other common lines of business.

The underlying data structure provides software developers all the tools to rapidly develop and customize applications without compromising data integrity. Modern tools and languages can be used with the platform to deliver common solutions including GUI, web services, and mobile apps.

Companies offering MV / Pick DBMS platforms include Rocket Software, Ladybridge, Revelation, and Northgate IS. InterSystems also supports full MV DBMS functionality in its Caché DBMS.

49 questions
4
votes
2 answers

Prevent a checkout in Git

I'm currently looking into managing source code from an OpenInsight application using Git. Because OI code is stored in a database table there is a certain amount of manual work to export the source to text and visa-versa. So far I have managed to…
ChrisMurray
  • 577
  • 1
  • 4
  • 21
3
votes
1 answer

Is there any way to use a more modern language with Pick Basic? D3 to be exact

So been on the Pick system since the 70s. Everything we have is done in Pick. I would like to maintain the Pick records but use another language such as Java for front end user interfaces. The issue is D3 seems to be locked away in the linux…
Sparky2146
  • 31
  • 2
3
votes
3 answers

Constants in pick/UniVerse database

How to declare a constant value in PICK/UniVerse database? How to pass an argument to a function by constant reference? There is some information in the IBM's manual for UniVerse database about constants, but nothing in particular. Please note…
Code_So1dier
  • 921
  • 1
  • 6
  • 15
3
votes
5 answers

UniVerse RetrieVe how do I query a file for all of its columns' values?

Kind of a follow up to my self-answered question about finding the column names. In UniVerse you can't query a file for all of its columns unless the @ phrase in your file's dictionary is set to all of the tables columns. If it isn't, how do you…
Evan Carroll
  • 78,363
  • 46
  • 261
  • 468
2
votes
1 answer

Possible DB.TOXML bug? (UniVerse 11.3.1 on AIX)

Based on my understanding of the XMAP specification relative to DB.TOXML, the following XMAP represents a simple object model containing two child tables with the same parent table. The command DB.TOXML CUST_ACT.XML XMAP_CustomerActivity.XML…
spencer741
  • 965
  • 1
  • 10
  • 22
2
votes
1 answer

Pick/UniBasic Field function that operates with a delimiter of more than one character?

Has there ever been an implementation of the field function (page 311) in the various flavors of Pick/UniBasic etc. that would operate on a delimiter of more than one character? The documented implementations I can find stipulate one character as…
spencer741
  • 965
  • 1
  • 10
  • 22
2
votes
3 answers

How do I perform these common administrator D3 multivalue tasks in jBASE?

jbasemultivalue-databasepickmultivalue This is how D3 lists the accounts in the system. SORT ONLY MDS WITH A1 = "D]""Q" Not sure how to do this in jBASE. This is how D3 lists the users that can log into the system. SORT USERS Not sure how to do…
JohnW
  • 23
  • 4
2
votes
3 answers

.NET and Pick Database D3

I want to connect my .net application with D3 pick database 9.0 (Windows version). In Earlier days, people used ODBC driver from Pick to write VB6 applications connecting with D3. Can I use same driver for .NET application? Pick also provides .NET…
helloworld
  • 2,179
  • 3
  • 24
  • 39
2
votes
1 answer

Using variable string in typing in Typescript

I need a function, that alters a specific variable in my Object: function updateField(fieldname, newValue){ return {...this.oldObject, fieldname: newValue}; } And I want to make it Typesafe. Type of fieldName is typeof clazz, but what is the Type…
Dániel Somogyi
  • 730
  • 7
  • 19
2
votes
2 answers

Universe/U2/Pick ICONV()

In U2/Universe/Pick, there is a function ICONV("11/11/15","D") to convert an external date to an internal date but this will work in USA or with the date format mm/dd/yyyy only. How can I use this function for UK date format (dd/mm/yyyy) ?
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
1 answer

using git with Pick D3 database

Is there a way to use git with Pick D3 database since the source code and compiled programs are stored inside D3? I think the only option would be to build routines to import/export the source code into the files in D3, but that seems like a lot of…
Adam
  • 21
  • 2
2
votes
1 answer

Writing a table to a file using D3 pick

In D3, suppose I have a file called foo and I want to write the contents of the file out to /var/tmp/bar. The documentation leads me to believe that it should be possible to make D3 write the file to the file system by changing the D pointer into a…
zelinka
  • 3,271
  • 6
  • 29
  • 42
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…
1
2 3 4