View previous topic :: View next topic
|
Author |
Message |
Nasy459762
New User
Joined: 19 Aug 2015 Posts: 4 Location: US
|
|
|
|
Hi.
I wanted setup a db2cobol program to pull data from Unix database table and compare with mainframe db2 data in my program. |
|
Back to top |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
Yeah. Good to know that. So, you said you 'wanted'.. did you change your mind? No need to tell others if you did. And even if you didn't. |
|
Back to top |
|
|
Nasy459762
New User
Joined: 19 Aug 2015 Posts: 4 Location: US
|
|
|
|
My Bad , I am looking for a setup. I dont know how to setup a connection from mainframe to UDB and pull the data. CAn you help me on this?? |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
What does your site support group say? Since connections can be specified by the site, what someone tells you to work for their site may not do anything at your site. You need to work with your site support group to get the connection parameters correct. |
|
Back to top |
|
|
Nasy459762
New User
Joined: 19 Aug 2015 Posts: 4 Location: US
|
|
|
|
Can you show me an example? My coboldb2 program is ready, now I want to pull data from UDB table. What all steps I need to take? Any specific CODE that I need to put in program? |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
As Robert says - speak to your support - especially your DBAs. That is what they are there for - to help you get things right. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
and since You have issues with a cobol/db2/udb environment
why did You post to the clist/rexx section ? |
|
Back to top |
|
|
Nasy459762
New User
Joined: 19 Aug 2015 Posts: 4 Location: US
|
|
|
|
I am a new user to this site and mistakenly posted in CLIST & REXX. Will take care going forward !!
Before posting my question in this forum, I reached my DBA and support and didnt get any help. So I was looking for any SME help here on topic. |
|
Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
First, you need a connection between your mainframe and the Unix server the data is on. We cannot tell you how to do this since the specifics will depend upon the software installed AT YOUR SITE, and the connection name will be custom TO YOUR SITE.
Second, with a connection between the systems, you will need to connect to the Unix data base. How to do this will depend upon the Unix data base (since you did not tell us which of the various Unix data bases you are using, there's not much more to be said) as well as site-specific values, and can only be discovered by someone working AT YOUR SITE.
Third, with a connection between the systems and a connection to the data base, you will then (and only then) be able to start doing data base actions (such as SELECT or INSERT). The specific commands will depend upon the Unix data base software and will be found in the manual for the software.
In other words, a lot of what you want can only be found AT YOUR SITE and hence asking on this forum is not going to help you much -- even if someone answers, the odds are low that anything you are told will apply to your site. You need to go back to your site support group and find someone you CAN work with to discover the various data you need to do what you want. |
|
Back to top |
|
|
|