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: 331
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: 7913
Location: Bellevue, IA

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: 1715
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: 10203
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: 2422
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: 7913
Location: Bellevue, IA

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 I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
This topic is locked: you cannot edit posts or make replies. How to move a long alphanumeric data ... lind sh COBOL Programming 8 Mon Dec 05, 2016 7:51 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts ODPP(Optim Data privacy Provider) Iss... Rama kishore IBM Tools 1 Mon Nov 07, 2016 5:46 pm


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