Importing data from DB2

[Mahesh]

Hi,
Is there any way to get the data from DB2. We are having a set of
queries and we want to import the output of these queries to Access tables.

I am able to import complete table data by using link table option but I
just want to get the output of the DB2 query to be imported to access. (We
tried running these queries after importing complete tables but it required
lot of modifications to the queries). We tried exporting the output to text
file and then importing to access but this is time consuming and maintainance
is becoming overhead as we have huge number of queries.

Is there any way I can get the data of the DB2 query output.

Thanks,
Mahesh

 

[Rick Brandt]

Hi,
Is there any way to get the data from DB2. We are having a set of
queries and we want to import the output of these queries to Access
tables.

I am able to import complete table data by using link table option
but I just want to get the output of the DB2 query to be imported to
access. (We tried running these queries after importing complete
tables but it required lot of modifications to the queries). We tried
exporting the output to text file and then importing to access but
this is time consuming and maintainance is becoming overhead as we
have huge number of queries.

Is there any way I can get the data of the DB2 query output.

Thanks,
Mahesh

A passtrhough query containing the identical SQL used on the server for the
query or a passthrough query that calls a stored procedure on the server or
have a View created on the server using that query and import the view.