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: 376
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: 8089
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: 1806
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: 10272
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: 2434
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: 8089
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 SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts NDM syntax checking without actually ... GAPX1 All Other Mainframe Topics 0 Wed Jun 07, 2017 2:36 am
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm
No new posts COBOL DB2 program - zIIP eligible vasanthz COBOL Programming 7 Wed May 31, 2017 5:12 am


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