You will also need a 3rd pary ODBC driver. We use a driver from OpenLink to connect from UV to SQL 2005, and I think others on this list have successfully used EasySoft. I did a trial of EasySoft many years ago but ran into problems getting it to work on RedHat AS 3. Their support was in the UK and it just wasn't worth the frustration waiting a day for each email reply. I'm pretty sure we started using BCI and ODBC at UV 9.6. We're currently on 10.2.7.
-John -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Friday, December 09, 2011 3:00 PM To: 'U2 Users List' Subject: Re: [U2] Universe and SQL Sorry, I'm a UD guy. Not sure when EDA was added to UV - but yes, it is powerful. No, you can't use syntax quite like that. You can use BCI - see the UniVerse BASIC SQL Client Interface Guide for syntax and examples. What it does is create an ODBC connection that you can use - much like below. Colin -----Original Message----- From: Wjhonson To be clear, I'm only trying to query the database at the moment. EDA looks pretty powerful, IF you upgrade. Can I execute a command in Universe like SELECT NAME, ADDRESS, ZIP FROM someexternaldatabase WHERE DATE = TODAY() ORDER BY DATE Can I do that in Universe 9.6 ? Or 10.2 ? And it will use the built-in SQL processor that comes with Universe ? Not to update the database, just to query from it? And if so, is there documentation on doing this query from an external database ? -----Original Message----- From: Colin Alfke Sure. They have EDA (originally a number of SQL type DB's but IBM reduced to B2 and now Rocket is adding them back) and BCI - an ODBC connection irectly from Basic. hth olin Alfke algary, Canada -----Original Message----- rom: Wjhonson see a lot of stuff on Universe accessing it's own files as SQL tables, and lso on how you can use OLE to access Universe tables using SQL. But can Universe, access SQL tables which are *not* in Universe? hey are just other SQL tables in other places around the network that sually is update by other non Pick software. Can Universe also access those tables? _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users