Category Archives: mvdbs

All the mvdbs.com and u2blog.org posts.

What happened in 1986?

Posted on July 21, 2011 by davidjmurray

I have been rather busy of late, doing a bit of reading and a lot of research regarding the NF² or The Nested Relational Model. While browsing my old Universities library last year, I discovered an old text book on … Continue reading →

Posted in General, mvdbs, Publications, RANT, SQL, Technologies | Tagged , | Leave a comment

Document Paradigm in UniBasic

Posted on May 16, 2011 by davidjmurray

Yet again, while running around the great inter-web, I found an interesting article which compares different database paradigms. The comparisons provided are between relational, document, key/value, and column-oriented databases. This lead me to thinking back to a comment that someone … Continue reading →

Posted in Idea!, mvdbs, SystemBuilder, Techniques, UniBasic | Tagged , , | Leave a comment

How to time travel with @DATE

Posted on February 28, 2011 by davidjmurray

Way back in Feb. 2008, I started to write this article about an interesting @DATE pass-by-reference issue. Then I got sidetracked. So, this bug existed in whatever version was trialware at that time. Guess what? It still exists in 10.3.7.0 … Continue reading →

Posted in Bugs, Code, mvdbs, U2, unFeature, UniBasic | Tagged , , , | Leave a comment

DRY Subroutines

Posted on February 26, 2011 by davidjmurray

The principle of DRY has been around for sometime. When applied to the PICK/U2 environment, there are two main methods of implementation via routines – internal subroutines (GOSUB) and external subroutines (SUBROUTINE/FUNCTION). But the relationship between these two methods and … Continue reading →

Posted in Code, Idea!, mvdbs, SystemBuilder, Techniques, UniBasic, UniVerse | Tagged , , | Leave a comment

UniVerse 11.1 Non-Feature Alert

Posted on February 24, 2011 by davidjmurray

Within the New Features documentation of UniVerse 11.1 is a section call Miscellaneous New Features which explains how to use a subroutine within a indexed field for auditing – index-based subroutines! This method of calling a subroutine during file access … Continue reading →

Posted in Bugs, mvdbs, News Items, Rocket Software, unFeature | Tagged , | Leave a comment

Friendfeed and EDA

Posted on February 17, 2011 by davidjmurray

The new release of UniVerse – 11.1 – now has the EDA capabilities that have been in Unidata for some time. But, is this a common method of storing non-1NF data in a 1NF database? This article about friendfeed also … Continue reading →

Posted in Idea!, MS-Access, mvdbs, Techniques, unidata, UniVerse | Tagged , , | Leave a comment

MS-Access 2010 and Calculated Fields

Posted on October 31, 2010 by davidjmurray

The new version of MS-Access (2010) has the ability for calculated fields. You may already know this concept as virtual fields, I-Descriptors, derived fields, or if you are rather long-in-the-tooth; correlatives within U2. So, does MS-Access 2010 have the same … Continue reading →

Posted in 4GL, I-Types, Idea!, MS-Access, mvdbs, Techniques | Tagged , | Leave a comment

Rocket Software Latest Newsletter

Posted on July 28, 2010 by davidjmurray

Rocket Software, the owners of the U2 products have just issued their latest newsletter with some interesting bits and pieces.

Posted in Events, mvdbs, Rocket Software, U2 | Tagged , | Leave a comment

New release of Cedarville Download

Posted on July 23, 2010 by davidjmurray

To my surprise, the data extraction reporting tool from Cedarville University for the U2 product range has a new release – version 7.40!

Posted in mvdbs, News Items, U2 | Leave a comment

Python to InterCall

Posted on July 5, 2010 by davidjmurray

One of the API’s provided by the U2 range of products within the UniDK  is InterCall. This package provides access to U2 data and the ability to execute commands, including UniBasic programs in a non-SQL manner. It is also possible … Continue reading →

Posted in mvdbs, Python, U2, UniVerse | Tagged , | 2 Comments