Could Kris use an I-descriptor to call a BASIC SUBRoutine that uses BCI to retrieve the value in the SQL database?
Tom Firl > -----Original Message----- > From: David Beahm [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 06, 2004 2: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