Rocket U2 (Old IBM Universe)

Unity Engine
1

I have ran into a snag, I need to get Unity to do a LISTFILES result pull from Universe, I can create new files in Universe, add data to the system, pull data from the system, but one thing that I simply can’t get it to do is return a list of files, however the word “files” here is a different meaning, a “file” is the same as a “database” with respect to other systems, and their doesn’t seem to be a core database master file that houses a list of existing databases in the system by name selection, so if anyone knows U2 and another way, like a sql statament to retrieve the list of “databases” it would be greatly appreciated. I realize not to many people work with anything more than MySQL or postGRESQL so I am taking a shot in the dark and hoping someone around here has worked with Universe before.

2

try LISTF

failing that the following should work:

SORT ONLY VOC WITH F1 LIKE “F…” OR WITH F1 LIKE “Q…”

3

Those will work with UniObjects command shell at the console of the Unix box, they however don’t work with the UniODBC connector otherwise LIST VOC would work also but I get a return error from UniODBC with unknown VOC. Very frustrating, thanks for the info though. I haven’t figured out yet how to get native UniObjects to work with Unity.

4

Figured it out, after the connection is open, simply use the connection to get the schema results from the “Tables” and populate that into a datatable. Had a buddy help out with that, didn’t think it would be that simple. Don’t need UniObjects for that, just the UniODBC driver and it works. Will get the latest of the U2.NET driver in a few weeks and see how that works out.

5

good to see you’ve found a solution.

you know i’m always surprised to see UniVerse (or any multivalue database) mentioned in any forum, much less a game dev one :slight_smile:

definitely a +1 for thinking out of the box on that choice.

6

U2 is definately an interesting creature, being as you stated, multi-value and has no real relational model, but I find that U2 is better suited for the MMO layer because data streaming in and out of it is very fast with less overhead than say Oracle or even SQL, it even beats DB2 for transaction handling. Not to many people around using a system like U2 to handle these things simply because wrapping ones brain around nested tables and fields that are nothing more than string delimited items is really hard to fathom. Thanks again for your help though :slight_smile: