|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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. |
|
#2
|
||||
|
||||
|
Can't you just place everything in DB2 or SQLServer, you'd get rid of 99% of your troubles
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
|
#3
|
|||
|
|||
|
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.
|
![]() |
| Viewing: Dev Shed Forums > Databases > DB2 Development > How to read from sql server and populate db2 tables real time |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|