Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-10 : 09:19:43
|
Winston writes "O.K. Here's my problem
I have a web page that does huge calls(Distinct) against MVS/DB2 databases
These can take up to 3 minutes to return. This is obviously not acceptable.
The data itself doesn't change more that once a day but currently the application is set-up that every user has to perform these calls every time they logon.
(I know it's stupid, but i got stuck with having to re-write this mess)
I do have access to a SQL7 Server. Is it possable to set-up a Scheduled task that would have SQL7 talk to my MVS/DB2 and pull the recordset back to SQL7?
This way i would only need to read the results from the SQL7 DB
So, My question is, Is there any problem retrieving data from DB2 thru SQL7? Do i need to set-up a DSN on SQL7 for the DB2?
etc...
any help or ideas will be appreceiated
Thanks
winston mac mahon" |
|
|
|
|
|
SQL/DB2