473,624 Members | 2,629 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

.NET integration and development - best version of DB2 to use, tools, etc?

My new client is running DB2 6.1 on IBM mainframe (z/OS).

They are running DB2 Connect ver. 7.2 to connect to database. (If you
cannot already tell, I'm new to DB2.) I'm not sure what DB2 Connect
does for them, as I have not yet interviewed mainframe development
staff at client company. I assume that it eases coding to access
back-end DB2 database from front-end mainframe source code - is this
true?

I am going to help build .NET pieces of legacy application, based on
mainframe
coding technologies, and platform. As well, I will be converting
current pieces of application from green-screens to .NET/Windows UI.

What is my best solution, including: upgrading either DB2 itelf, DB2
Connect (if necessary), or other IBM or 3rd party tools as add-ins.
I'd like to develop code for .NET Framework 1.1 on Visual Studio.NET,
so VS.NET compatibility would be best for this solution.

Fred Z.
Nov 12 '05 #1
3 2193
First DB2 V7.2 is going out of service very soon if not now, actually.
DB2 Connect is needed only if you are attempting to connect DB2 UDB
clients TO your V6.1 z/OS subsystem.
IF the flow is the other direction, you don't need anything but DB2 UDB
on UNIXX, LINUX,WINDOWS on one side and DB2 z/OS on the other.

I believe that DB2 UDB for LUW V8.2 is required if you plan to run .NET
apps. on the db. but I may be wrong here. I know that V8.2 introduced
a lot of enhancements just for that. Go on the DB2 web site to
investigate or to www.db2mag.com for a discussion on developping with
..NET. Article: Totallt RAD: Developping with .NET

Given .NET and DB2 UDB requirements, I'd convince the client to go to
most recent versions. I don't have my docs. handy to see what version
of z/OS is/is not supported by which version of DB2 UDB Connect.
HTH, Pierre.

Fred Zimmerman wrote:
My new client is running DB2 6.1 on IBM mainframe (z/OS).

They are running DB2 Connect ver. 7.2 to connect to database. (If you
cannot already tell, I'm new to DB2.) I'm not sure what DB2 Connect
does for them, as I have not yet interviewed mainframe development
staff at client company. I assume that it eases coding to access
back-end DB2 database from front-end mainframe source code - is this
true?

I am going to help build .NET pieces of legacy application, based on
mainframe
coding technologies, and platform. As well, I will be converting
current pieces of application from green-screens to .NET/Windows UI.

What is my best solution, including: upgrading either DB2 itelf, DB2
Connect (if necessary), or other IBM or 3rd party tools as add-ins.
I'd like to develop code for .NET Framework 1.1 on Visual Studio.NET,
so VS.NET compatibility would be best for this solution.

Fred Z.


--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #2
A data provider for .NET v1.0 was available in V81 FP2. A v1.1 provider
was added in V81 FP3. Performance improvements for both went into FP4.

Support for .NET routines (ie, UDFs and procedures) were added in V82
(aka FP7) as LANGUAGE CLR. This requires a minimum of .NET v1.1
installed on the server.

Pierre Saint-Jacques wrote:
First DB2 V7.2 is going out of service very soon if not now, actually.
DB2 Connect is needed only if you are attempting to connect DB2 UDB
clients TO your V6.1 z/OS subsystem.
IF the flow is the other direction, you don't need anything but DB2 UDB
on UNIXX, LINUX,WINDOWS on one side and DB2 z/OS on the other.

I believe that DB2 UDB for LUW V8.2 is required if you plan to run .NET
apps. on the db. but I may be wrong here. I know that V8.2 introduced
a lot of enhancements just for that. Go on the DB2 web site to
investigate or to www.db2mag.com for a discussion on developping with
.NET. Article: Totallt RAD: Developping with .NET

Given .NET and DB2 UDB requirements, I'd convince the client to go to
most recent versions. I don't have my docs. handy to see what version
of z/OS is/is not supported by which version of DB2 UDB Connect.
HTH, Pierre.

Fred Zimmerman wrote:
My new client is running DB2 6.1 on IBM mainframe (z/OS).

They are running DB2 Connect ver. 7.2 to connect to database. (If you
cannot already tell, I'm new to DB2.) I'm not sure what DB2 Connect
does for them, as I have not yet interviewed mainframe development
staff at client company. I assume that it eases coding to access
back-end DB2 database from front-end mainframe source code - is this
true?

I am going to help build .NET pieces of legacy application, based on
mainframe
coding technologies, and platform. As well, I will be converting
current pieces of application from green-screens to .NET/Windows UI.

What is my best solution, including: upgrading either DB2 itelf, DB2
Connect (if necessary), or other IBM or 3rd party tools as add-ins.
I'd like to develop code for .NET Framework 1.1 on Visual Studio.NET,
so VS.NET compatibility would be best for this solution.

Fred Z.


Nov 12 '05 #3
Thanks for the update. I've kept a copy of this.
Merci, Pierre.

amurchis wrote:
A data provider for .NET v1.0 was available in V81 FP2. A v1.1 provider
was added in V81 FP3. Performance improvements for both went into FP4.

Support for .NET routines (ie, UDFs and procedures) were added in V82
(aka FP7) as LANGUAGE CLR. This requires a minimum of .NET v1.1
installed on the server.

Pierre Saint-Jacques wrote:
First DB2 V7.2 is going out of service very soon if not now, actually.
DB2 Connect is needed only if you are attempting to connect DB2 UDB
clients TO your V6.1 z/OS subsystem.
IF the flow is the other direction, you don't need anything but DB2
UDB on UNIXX, LINUX,WINDOWS on one side and DB2 z/OS on the other.

I believe that DB2 UDB for LUW V8.2 is required if you plan to run
.NET apps. on the db. but I may be wrong here. I know that V8.2
introduced a lot of enhancements just for that. Go on the DB2 web
site to investigate or to www.db2mag.com for a discussion on
developping with .NET. Article: Totallt RAD: Developping with .NET

Given .NET and DB2 UDB requirements, I'd convince the client to go to
most recent versions. I don't have my docs. handy to see what version
of z/OS is/is not supported by which version of DB2 UDB Connect.
HTH, Pierre.

Fred Zimmerman wrote:
My new client is running DB2 6.1 on IBM mainframe (z/OS).

They are running DB2 Connect ver. 7.2 to connect to database. (If you
cannot already tell, I'm new to DB2.) I'm not sure what DB2 Connect
does for them, as I have not yet interviewed mainframe development
staff at client company. I assume that it eases coding to access
back-end DB2 database from front-end mainframe source code - is this
true?

I am going to help build .NET pieces of legacy application, based on
mainframe
coding technologies, and platform. As well, I will be converting
current pieces of application from green-screens to .NET/Windows UI.

What is my best solution, including: upgrading either DB2 itelf, DB2
Connect (if necessary), or other IBM or 3rd party tools as add-ins.
I'd like to develop code for .NET Framework 1.1 on Visual Studio.NET,
so VS.NET compatibility would be best for this solution.

Fred Z.



--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.
Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
4211
by: Rick Kopnisky | last post by:
I am unable to get the VSS Integration with InterDev to work after reading the Microsoft support articles and searching through the usenet using Google groups. I have read MS Knowledge Base Article - 171116 and enabled FrontPage logging as described in 191289 I am still getting the 'User "" not found' message in the event log on the web server even after enableing the "Use Netwrk name for automatic login" in VSS Administrator Here are the...
5
3735
by: Doug Broadwell | last post by:
I'm getting ready to start a fairly large application to be hosted on SQL-Server. In the past I have used Access 2002 (as a front end, wasn't happy with the number of bugs I ran into), PowerBuilder 6.5, Oracle Forms 7 years ago (also no happy with the number of bugs). I was curious what the state of the art was these days and what current recommendations were for 4GL type of development tools. Thanks, Doug Broadwell
0
2298
by: Stylus Studio | last post by:
DataDirect XQuery(TM) is the First Embeddable Component for XQuery That is Modeled after the XQuery API for Java(TM) (XQJ) BEDFORD, Mass.--Sept. 20, 2005--DataDirect Technologies (http://www.datadirect.com), the software industry leader in standards-based components for connecting applications to data and an operating unit of Progress Software Corporation, today announced the release of DataDirect XQuery(TM), the first embeddable...
8
3138
by: John Baker | last post by:
Hi: I am URGENTLY in need of some book or web site OR tool that will help me integrate a relatively simple access application into a web page or pages. This is a time recording system (by project), and I would be more than wiling to pull the updated database down from the Host using FTP on a monthly basis. Its just that I need to understand how to set it up on the web site itself. The Host supports SQL. Any direction you can give would...
8
4054
by: Ben Bartsch | last post by:
Looking for opinions on the use of Flash with ASP.NET. Has anyone here seen or conducted any implementations of Flash that are actually useful or otherwise complement ASP.NET?
0
1331
by: YellowfinTeam | last post by:
Yellowfin is proud to announce the release of 3.1. The major theme of this release is enhanced integration capability. We have introduced a range of new web services and authentication processes that allows for Yellowfin to be integrated into any environment with ease. These changes include: * Single signon capability * Report List API * Person Update Services
2
1711
by: Tom van Stiphout | last post by:
Imagine opening SQL Server Management Studio (SSMS), drilling into a database, and seeing all objects with little lock symbols in front of them. That would be true SS integration. Maybe next version? I know about creating a project in SSMS and managing connections, queries, and misc there, but come on, that seems a far cry from what I long for. I searched for 3rd party tools and found SQLSourceSafe and Apex SQL
2
3167
by: lmaurer | last post by:
Hi all, I have been charged with learning how to create web pages that will function as data capturing tools. From the research I have done, it looks like I need to learn ASP.net and SQL Server (langauge and how to create databases in SQL Server). My question is where is the best place to start learning these tools? Are courses in ASP.NET and Intro to SQL server where I should start or are there even more basic items I need to learn...
3
1518
by: webnewbee | last post by:
All, I am an absolute beginner when it comes to web development. I have built a few sites using tools like FrontPage and WebPlus, but when it comes to programming in HTML, XML, .Net etc., I am as green as a new leaf. The web development tools help me put aweb site together very quickly using templates for layouts etc. I now want to take it to the next level where I can integrate it with databases and run API's to gather information from...
0
8249
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8179
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8685
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
6112
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5570
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4084
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2613
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1797
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1493
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.