|
View previous topic :: View next topic
|
| Author |
Message |
varesh.et
New User
Joined: 04 Jul 2010
Posts: 1
Location: Pune
|
|
|
|
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 |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
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 |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| 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'.... 
[/rant]
| varesh.et wrote: |
Occupation: Software engineer
Mainframe Skills: TSO, ISPF, JCL, COBOL, DB2, IMS/DB, DC |
|
|
| Back to top |
|
|
|
|
