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
 

 

Need to know how can I write a program for DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
varesh.et

New User


Joined: 04 Jul 2010
Posts: 1
Location: Pune

PostPosted: Tue Jul 06, 2010 4:11 am    Post subject: Need to know how can I write a program for DB2
Reply with quote

Hi, I am working for one of MNC. I have to write one COBOL-DB2 program, where I need to retrieve rows by using two keys. one with key A+B and other with only A. This table will have 35 pairs of columns+key(A+B) defined. I will be retrieving one pair of 35 columns at a time by using either of above key. However while inserting/updating data into this table I will not be having all the 35 columns data at a time. I am wondering how can I design this table and program, so that I can deal with this table for update, select or insert function if I will be having all 35 column data at a time or a piece of data out of these 35 columns at a time.

Please let me know your thoughts and suggestion.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Tue Jul 06, 2010 5:27 am    Post subject:
Reply with quote

Here is a link to an Application and Programmers Guidewhich will pretty much explain all,
as well as providing examples of programs, which can be found in the appendix.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Tue Jul 06, 2010 5:34 am    Post subject: Re: Need to know how can I write a program for DB2
Reply with quote

varesh.et wrote:
I have to write one COBOL-DB2 program, where I need to retrieve rows by using two keys. one with key A+B and other with only A. This table will have 35 pairs of columns+key(A+B) defined. I will be retrieving one pair of 35 columns at a time by using either of above key. However while inserting/updating data into this table I will not be having all the 35 columns data at a time. I am wondering how can I design this table and program, so that I can deal with this table for update, select or insert function if I will be having all 35 column data at a time or a piece of data out of these 35 columns at a time.

[rant]
Why claim 'skill' in an area that you do not have?
Drop the DB2 entry or at least preface it with 'learning'.... icon_rolleyes.gif
[/rant]
varesh.et wrote:

Occupation: Software engineer
Mainframe Skills: TSO, ISPF, JCL, COBOL, DB2, IMS/DB, DC
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts Need to write record of PS File in ex... Chandan1993 JCL & VSAM 1 Wed Jun 07, 2017 1:35 am


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