IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to Pull data from UDB using coboldb2 program


IBM Mainframe Forums -> COBOL Programming
Post new topic   Reply to topic
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
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: 446
Location: USA

PostPosted: Sat Aug 22, 2015 12:51 am
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
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Sat Aug 22, 2015 3:30 am
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
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: 2455
Location: Hampshire, UK

PostPosted: Sat Aug 22, 2015 4:02 am
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

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Sat Aug 22, 2015 12:31 pm
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
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: 2481
Location: Netherlands, Amstelveen

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

This info can be helpful :

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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Sun Aug 23, 2015 6:52 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> COBOL Programming

 


Similar Topics
Topic Forum Replies
No new posts Using API Gateway from CICS program CICS 0
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts Check data with Exception Table DB2 0
No new posts JCL EXEC PARM data in C Java & MQSeries 2
Search our Forums:

Back to Top