sifukurt has asked for the wisdom of the Perl Monks concerning the following question:

Does anyone have any experience with using perl to talk to a UniVerse database? I've got an old AIX system that has tons of data in a UniVerse database and I need to be able to access that data remotely. If anyone has suggestions for how to go about doing that, I'd appreciate it. In the interim, I'll keep experimenting.

Replies are listed 'Best First'.
(Ovid) Re: Connecting to UniVerse database
by Ovid (Cardinal) on Aug 29, 2001 at 01:36 UTC

    You may want to post to newsgroups if no one posts a solution for you here. At one company I worked for, we desperately needed some means of connecting to to a UniData database (very similar to UniVerse) and someone sent us the modules that he had written to do just that.

    Before we had access to that, I had routines that wrote out flat file versions of the data and then the Perl programs picked up that and ran with it. It wasn't an elegant solution, but it worked.

    I know this probably is not an option, but is there any chance you can switch to another database? Multi-value databases are really a pain to work with and, since they violate first normal form, they are difficult to get right.

    Side note: if anyone knows of normalization rules for multi-value databases, I'd be interested in seeing them. I don't work with them anymore, but I'm still curious :)


    Vote for paco!

    Join the Perlmonks Setiathome Group or just click on the the link and check out our stats.