Extract data from a DBMS called PI/Open on HP-UX

Hi.
I need to extract data from an old DBMS called PI/Open, it was manufactured once from Informix and some time ago IBM bought it and now they are replacing it with a new one called UniVerse. I need to extract data from this PI/Open in a periodic way, let it on a readable text file and record that info in a Windows system. I'm wonder if someone out there knows where to find the ODBC driver to access it from Windows or how to program the data extraction on HP-UX, maybe using cron or a deamon.

Thanks for your help.
mak730Asked:
Who is Participating?
 
allinbConnect With a Mentor Commented:
Take a look at this link....

https://www-927.ibm.com/software/data/u2/support/u2techconnect/uv10pe.asp

Never used it but it looks pretty close to what you need....Follow the link to the documentation as there is a section on how to use Windows ODBC connectivity to connect the database to a SQL Server..
This is a snippit from their documentation.... to make it even better it is freeware for a 2 user license.....

UniVerse BASIC SQL Client Interface Guide V 10.1 (G251-1910-00)
Describes how to use the BASIC SQL Client Interface (BCI), an interface to UniVerse and non-UniVerse databases from UniVerse BASIC. The BASIC SQL Client Interface uses ODBC-like function calls to execute SQL statements on local or remote database servers such as UniVerse, INFORMIX, ORACLE, Microsoft SQL Server, or SYBASE.
0
 
mak730Author Commented:
Yes it is usefull but the programs and some sintax does not match with PIOpen,  ODBC doesn´t seem to work neither, do you know where to find some PI/Open documentation?
0
 
mak730Author Commented:
Thanks allinb, I know this DBMS is almost a relic and it is hard to find something about it. The best info I found was in its own on-line help, I hope I never need to work with something like this DBMS in the future.

I appreciate your try.
0
 
allinbCommented:
It is the little challenges in life that make the big accomplishments become reality.....
Best of luck...
AB
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.