That was our first solution was updating a local file with the data from the sql table. I was hoping for something "a little more dynamic", but that is what you get with a "closed environment" that UniData is.
Still , I like the environment warts and all. Kris Stevens -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Beahm Sent: Thursday, May 06, 2004 4:52 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Get External Sql Data Dynamically BCI doesn't offer quite as tight an integration as that. What it gives you is the ability to read and write to SQL data sources from within UniBasic. For instance, we have a table that exists in MySQL, but we need to access the data from UniData (and for the moment we don't have time to change the user interface to support interfacing with UniData -- besides it made a good test case). Anyway, we were able to execute SQL queries against the external database from within a program. In your case, you might want to write a program that updates a local file with data from the SQL table. Then you can use all your familiar Retrieve logic (I-types, etc.) HTH, David Beahm Kris Stevens wrote: > Thanks for the response. > > Here is a followup question, to verify I am asking my question clearly. > > What I am trying to do is: > > List MYLocalFILE where MyRemoteKey = "X" MyRemoteData > > where the MyLocalfile is a local unidata mv file. > MyRemoteKey is a dict item that references the remote SQL table on the > network. > MyRemoteData is a dict item that returns the value from the remote SQL > table. > > The clients would not have any software installed, just the server only. > > Would this need to be done in a datatel subroutine? > > Thanks! > > Kris Stevens > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of David Beahm > Sent: Thursday, May 06, 2004 1:44 PM > To: [EMAIL PROTECTED] > Subject: Re: [U2] Get External Sql Data Dynamically > > > Yes, BCI is the tool. If you're on Unix, you also need to have an ODBC > manager. Being on 64-bit HP-UX (which makes it hard to find compatible > OTS software), we ended up using EasySoft's ODBC-ODBC bridge (they made > a custom port to HP-UX for us), which is working great. > > Best, > David Beahm > > Tom Firl wrote: > >>Take a look at BCI... this is the U2 feature that provides ODBC client > > functionality. I personally haven't used it, but several readers of this > group have... > >>Tom Firl >>Columbia Ultimate > > ------- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > ------- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
