Re: More Questions on INet

Bob Kane writes: |> Well we have INet working between our 3B2 and our HP 9000/375's, but I have |> a few questions on using it. What I would like to do is run a process on the |> HP that as an end result will insert a bunch of rows into the database on |> the 3B2. I find that when I point to the database on the 3B2 at the start |> of the program, all temporary tables and files are created on the 3B2. I |> would like to do all the interim processing on the HP and only insert the |> final result into the database on the 3B2. If I create a database on the |> HP for this purpose can I retain the values in an open cursor when I change |> the database to that on the 3B2? Any one done anything like this out there? |> Any help would be appreciated. This cannot be done. I-Net allows only one database to be accessed at a time. Since a cursor exists mostly in the server, when you switch dbs, you will loose access to the cursors in the other db. You could fetch the rows into local memory of some sort. Or, if you are using OnLine, you could use I-Star and do a distributed query. Dave