DB2 Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDB2 Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old July 16th, 2007, 10:12 AM
infinityizz infinityizz is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2007
Posts: 2 infinityizz User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 m 56 sec
Reputation Power: 0
How to read from sql server and populate db2 tables real time

Hi,
My application is cobol running on the mainframe. Our previous interface application was cobol and vsam, but is now migrated to sql server and dotnet. Our main application has a jsp front end and cobol back end. We would like to convert our main application from the cobol back end programs reading vsam files and updating db2 (and vice versa) to reading sql server and updating db2 and vice versa.

I was wondering if someone has recommendations on the best (or perhaps possible) ways of doing this. One option would be to call a java scriptlet within the jsp that goes against the sql server, but that gets into the presentation layer and away from best practises. Is it even possible for the cobol to read sql server? Sorry if these are newbie questions buuuut I wouldn't ask if I knew, right

thanks much.

Reply With Quote
  #2  
Old July 16th, 2007, 10:29 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
 
Join Date: Jun 2001
Location: Outside US
Posts: 7,808 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 21 h 29 m 33 sec
Reputation Power: 278
Can't you just place everything in DB2 or SQLServer, you'd get rid of 99% of your troubles

Reply With Quote
  #3  
Old July 16th, 2007, 10:41 AM
infinityizz infinityizz is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2007
Posts: 2 infinityizz User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 16 m 56 sec
Reputation Power: 0
Very true, but unfortunately not an option. Our application is written for cobol/db2. One of the interface applications we access is moving to dot net/sql server and is written by another development team.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDB2 Development > How to read from sql server and populate db2 tables real time


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway