• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 878
  • Last Modified:

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.
0
mak730
Asked:
mak730
  • 2
  • 2
1 Solution
 
allinbCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now