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
1
vote
1 answer

UniTransaction throwing NullReferenceException

I'm trying to begin a transaction however on calling the .Begin() method throws a NullReferenceException and the stacktrace shows that it is coming from IBMU2.UODOTNET.UniTransaction.ServerTransaction(Int32 aKey). Has anyone successfully used…
thames
  • 5,833
  • 6
  • 38
  • 45
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
4 answers

How to convert an internal numeric date to Access Date/Time format?

I get some data from a PICK/UniVerse database that includes dates in a 4 or 5 character numeric format. Here are some examples .. I grabbed the date values from the database, and compared it to the date being shown in an application: 9832 …
Jeff Brady
  • 1,454
  • 7
  • 35
  • 56
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…
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…
1
vote
3 answers

UniCommand differences for UniData

I'm new to the world of UniObjects as I've been in .NET land since it debuted. After building a simple app to return the select list of a UniCommand statement I noticed that there are some major differences in how UniData and how UniObjects parses…
thames
  • 5,833
  • 6
  • 38
  • 45
0
votes
2 answers

How can I make the new list created by my UV BASIC program the active list when executed from TCL like in jBase's OR-LISTS program?

We are trying to convert from jBase to Universe. I've written a UV BASIC program called MERGE.MY.LISTS that joins an arbitrary number of existing lists together and saves the new list to list MYMERGEDLIST. My intention is to replicate the OR-LISTS…
0
votes
0 answers

How to handle Image.file in flutter?

I'm getting images using the image_picker package and I have 2 problems. First How to get the image URI to upload it to Firebase storage? This is how I get the image: final ImagePicker picker = ImagePicker(); final img = await picker.pickImage( …
toufik s
  • 1
  • 1
0
votes
2 answers

D3 Pick Multivalue Database Access ODBC or other?

Hello I am very new to D3 Pick. Could you recommend some info on how to get access to a data file with possibly ODBC or SQL query? My IT department says ODBC is not possible but I think there must be a way. Maybe creating a new pointer file to be…
Jorge
  • 336
  • 1
  • 4
  • 15
0
votes
1 answer

Displaying the Line Number during the execution of a Pick Basic Program in uniVerse

I am utilizing Pick Basic on the uniVerse operating system. Many times, I will need to watch a variable change during a debugging session. I will locate the variable throughout the program and note every time it can possibly be modified. I will…
ButtonKLK
  • 1
  • 1
0
votes
1 answer

Game can't detect Winning

I am trying to make a little game. I tried to make the diagonal winning line, but it did not work. If I tried the normal winning line, it worked, but, only in the first 3 fields. I made a check_winner() function, where I detect all winning fields. I…
crvxッ
  • 60
  • 7
0
votes
5 answers

How to run a program with parameters (Pick BASIC)

In Pick BASIC source code I see lines such as CALL SOMEPROGRAM (PARAM1, PARAM2) How can I invoke that same line from the TCL command prompt? I've tried variations of the following but nothing seems to work. SOMEPROGRAM ('1','2') The only way I've…
PBeezy
  • 1,222
  • 2
  • 17
  • 26
0
votes
1 answer

Pick Query Distinct Rows

How do you select distinct rows from PICK database. Here's my query. I get lots of duplicate rows. SELECT ARIVAL WITH A.PROD.NO AND WITH WH.AR.DATE >= "01/01/18" AND WITH STATUS = "C" Is there any online documentation for Pick Queries?
Heap of Pinto Beans
  • 677
  • 2
  • 12
  • 23
0
votes
3 answers

Pattern Matching BASIC programming Language and Universe Database

I need to identify following patterns in string. - "2N':'2N':'2N" - "2N'-'2N'-'2N" - "2N'/'2N'/'2N" - "2N'/'2N'-'2N" AND SO ON..... basically i want this pattern if written in Simple language 2 NUMBERS [: / -] 2 NUMBERS [: / -] 2 NUMBERS So is…
Nitin Rathod
  • 159
  • 2
  • 15
0
votes
2 answers

PICK/BASIC, FlashBASIC, and C Interoperability

I stumbled across some interesting documentation regarding PICK programming: http://www.d3ref.com/?token=flash.basic It says FlashBASIC is a compiled, instead of interpreted, version of PICK programs that are interoperable with PICK. This is great.…
Jon
  • 1,820
  • 2
  • 19
  • 43