Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to Pull data from UDB using coboldb2 program

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
Nasy459762

New User


Joined: 19 Aug 2015
Posts: 4
Location: US

PostPosted: Sat Aug 22, 2015 12:37 am    Post subject: How to Pull data from UDB using coboldb2 program
Reply with quote

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
View user's profile Send private message

RahulG31

Active User


Joined: 20 Dec 2014
Posts: 371
Location: USA

PostPosted: Sat Aug 22, 2015 12:51 am    Post subject: Reply to: How to Pull data from UDB using coboldb2 program
Reply with quote

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
View user's profile Send private message
Nasy459762

New User


Joined: 19 Aug 2015
Posts: 4
Location: US

PostPosted: Sat Aug 22, 2015 3:06 am    Post subject: Reply to: How to Pull data from UDB using coboldb2 program
Reply with quote

My Bad icon_smile.gif , 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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8054
Location: East Dubuque, Illinois, USA

PostPosted: Sat Aug 22, 2015 3:30 am    Post subject:
Reply with quote

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
View user's profile Send private message
Nasy459762

New User


Joined: 19 Aug 2015
Posts: 4
Location: US

PostPosted: Sat Aug 22, 2015 3:36 am    Post subject: Reply to: How to Pull data from UDB using coboldb2 program
Reply with quote

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
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1787
Location: UK

PostPosted: Sat Aug 22, 2015 4:02 am    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10255
Location: italy

PostPosted: Sat Aug 22, 2015 12:31 pm    Post subject: Reply to: How to Pull data from UDB using coboldb2 program
Reply with quote

and since You have issues with a cobol/db2/udb environment
why did You post to the clist/rexx section ?
Back to top
View user's profile Send private message
Nasy459762

New User


Joined: 19 Aug 2015
Posts: 4
Location: US

PostPosted: Sun Aug 23, 2015 9:59 am    Post subject: Reply to: How to Pull data from UDB using coboldb2 program
Reply with quote

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
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2433
Location: Netherlands, Amstelveen

PostPosted: Sun Aug 23, 2015 12:08 pm    Post subject:
Reply with quote

This info can be helpful :

http://www.ibm.com/developerworks/data/library/techarticle/0310chong/0310chong.html
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8054
Location: East Dubuque, Illinois, USA

PostPosted: Sun Aug 23, 2015 6:52 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us