Re-directing Result sets from the user's desktop

How would I do the following:

  1. Run a query which creates a table on the data repository (Tandem servers) and inserts the results into that table. Any special settings in ODBC or BO for this capability?
  2. Retrieve those results at a later time through business objects

I am not referring to the functionality of Broadcast Agent, we are going to be using this tool too. I need a way to keep larger (> 1 million rows) datasets on the Tandem (our datawarehouse).

Kathy Vazquez


Listserv Archives (BOB member since 2002-06-25)