UniVerse is an extended relational data server with easy-to-understand data modeling that uses XML-like data structures to allow developers to quickly create embedded solutions. UniVerse delivers a high-performance, highly scalable, easy-to-use database offering for rapid deployment and rapid return on investment.
Questions tagged [universe]
166 questions
22
votes
2 answers
Trying to build PHP PDO extension for Rocket U2
I wonder if anyone can help me with a problem that is making me pull what's left of my hair out...
I am currently working on a project that requires me to talk to a Unidata database. PHP has no native driver to access this type of database, however,…

kaigoh
- 500
- 3
- 11
15
votes
5 answers
Pros and Cons of Multi-value Databases
I've just started a new job where I'm going to have to do a fair amount of work with a multi-value database (UniVerse). What little database experience I have is in relational databases (SqlServer) and I'm looking for some un-biased information…

Jackson Pope
- 14,520
- 6
- 56
- 80
9
votes
2 answers
UniVerse learning materials
I've recently come in contact with a proprietary descendant of UniVerse. Does anyone know where I can get a good tutorial or brush up on the syntactic quirks of its more popular parent? I can't figure out how to even get a table listing. Navigating…

Evan Carroll
- 78,363
- 46
- 261
- 468
8
votes
1 answer
Multi Value Separator with .net C#
When we use C# with the Universe database the multi values are coming from the Universe Database as comma separated values to the programming site. Normally in Pick Basic language programming they come up as a ^252 or ^253 separated values.…

Explorer
- 295
- 1
- 12
5
votes
3 answers
Connecting PHP to IBM UniVerse
I have a very simple question. We have an IBM UniVerse server and I want to connect to it through PHP in the same manner that I use to connect to MySQL. I do not know any other information (server version, age, etc). All I know is that it runs on a…

achilles
- 119
- 1
- 9
5
votes
2 answers
what's the difference between MATREAD and READ?
I need to understand the difference between MATREAD and READ? and please provide a simple example on where and how to use one.

TMAN-MAN
- 141
- 1
- 2
- 13
4
votes
1 answer
In Idris, can IO happen in any universe?
That's my question. Idris has a cumulative universe hierarchy where the universe is inferred by the compiler. Does the use of dosomethingreal : IO imply the lowest universe in the hierarchy? Is IO : Type and never IO : Type 1? Or can I have IO…

ruben.moor
- 1,876
- 15
- 27
4
votes
1 answer
SSIS vs. DTS performance
Seems crazy to be doing this at this late date, but...
I am rebuilding some ETL infrastructure with a Rocket Software UniVerse source and an SQL destination. The old destination platform was SQL 2000 on Windows Server 2003, the new platform is SQL…

stinkyP
- 555
- 6
- 14
4
votes
2 answers
How can I get schema information about a UniData/UniVerse database?
I have some (limited) experience with UniData and UniVerse databases and now wanting to work with them via the .NET framework. It appears that the way to work with them now is via Rocket Software's U2 Toolkit for .NET.
Since I will be accessing…

ksigmund
- 527
- 1
- 6
- 13
3
votes
3 answers
What is the best way to handle authentication in ASP.NET MVC with a Universe database?
We use an IBM database known as Universe that holds all of our user id's, passwords, and profile information in a table called USERINFO.
Can I use the Membership Provider to connect to this database and authenticate the user?
The database access…

Mike Roosa
- 4,752
- 11
- 40
- 52
3
votes
2 answers
UniObjects for Java how to open sessions to emulate connection pooling
I'm developing an API that connects UniVerse database to a REST endopoint.
The problem is that we dont have license for native connection pooling using the UniVerse library for Java.
This software is developed in Java using Spring Boot, and the way…

becodev
- 41
- 2
3
votes
1 answer
Attempted READ of key larger than file maximum key size
I'm running a program to help document what is contained in our 30+year old database. During the course of this process, I am getting the following error message:
Attempted READ of record ID larger than file/table maximum record ID size of 255…

Charles
- 355
- 1
- 2
- 12
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
1 answer
How to do fetch pages when querying universe database using .net sdk and sql
I am connecting to a universe database (from rocket software) using their .net driver. I would like to fetch data on demand on user request per page i.e. do pagination. With other databases we could use (offset fetch) but universe db doesn't seem to…

Bhupendra
- 1,725
- 22
- 30
3
votes
2 answers
IBM U2 (UniVerse 10.2) - Create Schema - How
We have a traditional UV account. Data files in one directory, application programs & subroutines in another directory. Our latest projects is implementing JDBC and in order to fully access the subroutines from java, I belive I need to create a…

user41474
- 31
- 2