Folks,

As it turns out, it's actually something called UniData RDMBS, version
5.2.
Since Informix has bought the company that owned UniData, the package
is shipped by Informix, so, the client thought it's Informix database.

Now, the first thing I'd like to do is to get to know the data schema,
any way to generate an ERD type of thing with it?

Thanks.

Jean Sagi <jeansagi (AT) myrealbox (DOT) com> wrote

Doug Baroter wrote:
The home page for IBM's "UniData" and "UniVerse" databases is
http://ibm.com/software/data/u2
and you'll find links there to answer your questions.

"UniData" and "UniVerse" are 2 different products, but they're
similar, and IBM refers to them collectively as the "u2" products.

IBM has a single group, based in Denver, doing engineering and
marketing for both products. They're great folks and they
can also provide you with IBM consultants or refer you to
independent consultants in your area.

The reason why you might need a consultant is that most UniData
applications don't have a schema, and the data dictionaries are
typically full of holes and mistakes, in which case you have to
build a schema by reverse engineering the UniBasic application,
which is a non-trivial task.

If the application came from one of IBM's VARs, then IBM's
consultants probably won't touch it, because IBM doesn't want
to disturb their VARs.

Most Unidata-based applications are from independent software
vendors, also known as VARs, and commonly the UniBasic source
code is only at the VAR's office, not at the end-user's office,
in which case the only good way to build a good schema is to go
back to the original VAR and pay them to do it.