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' <u2-users@listserver.u2ug.org>
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

Reply via email to