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 <alfke...@hotmail.com> To: 'U2 Users List' <email@example.com> Sent: Fri, Dec 9, 2011 1:58 pm Subject: Re: [U2] Universe and SQL 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? _______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users