| View previous topic :: View next topic |
| Author |
Message |
Vreddy
Beginner
Joined: 03 Feb 2003
Posts: 12
Topics: 5
|
 Posted: Wed May 28, 2003 1:09 pm Post subject: SQL server database |
 |
|
Can i SQL server database from COBOl/DB2 program running in mainframe. The reason for this is some information is in DB2 and some information is in SQL server databse. I need to extract the information from SQL server using SQL stored procedures.
Can i call SQL stored procedure from COBOL/DB2 program
Thanks
_________________
Thanks
Vreddy |
|
| Back to top |
|
 |
Meera
Beginner
Joined: 27 Jun 2003
Posts: 7
Topics: 0
|
| Posted: Wed Jul 09, 2003 11:06 am Post subject: |
|
|
| sure you can - if your site has MQ-Series and YOU do the leg-work. But, usually, no one in their right mind would do this; you may want to access both data from a VB/ADO app instead !! |
|
| Back to top |
|
|
zatlas
Beginner
Joined: 17 Dec 2002
Posts: 43
Topics: 4
|
| Posted: Wed Jul 09, 2003 12:12 pm Post subject: |
|
|
On the other hand, the mainframe DB2 could easily be available on the other side, providing you have an appropriate ODBC driver... [there are several available, for a fee  ]. So you could do your process in the dinky Windows server/SQL server and acquire the DB2 data.
Well, assuming, of course that you do not have to extract data from REAL DB2 tables with gazillion of rows as this would strain your network and bring the Windows down to its knees. In any case, you should consider coding stored procedures and maintain most of the workload in the REAL computer and out of the toy machines 
ZA |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
