[EMAIL PROTECTED] wrote: > I am a bit of novice when it comes to the UniVerse database but I am trying to dive > into it and learn as much as I can. I am also new to the mailing list, so my > apologizes if I have gone about this the wrong way. > > My problem is this: I am running an AIX 4.3.3 with UniVerse database 10.1 > installed. I am hosting my companies website from Linux running the osCommerce > shopping cart that backends all the information in a mySQL database. > > Instead of having to type in all 250,000 items into the mySQL database, I want to > real time the lookups with our own database. Is there a way for mySQL to look up > the tables in UniVerse, or is there a better way? > There's no need to type them all in.
UV will happily export in a relational manner (look up things like OLE and ODBC) although I don't know how easy it is to get MySQL to read stuff from another database like that. The alternative is, do you know how to create a table and populate it using MySQL commands? An approach I'd look at is a simple prog that dumps a UV file into a SQL script - run the script in your RDBMS and there's a table with all the data in ... Cheers, Wol ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
