|
View previous topic :: View next topic
|
| Author |
Message |
ibmmainframesyntel
Active User
Joined: 26 Feb 2007
Posts: 126
Location: Chennai
|
|
|
|
Hi ,
I have to extract only the primary key of th DB2 table into flat file.
Using that extracted primary key,have to extract two more fields from another table in the flat file.
Is that possible thr JCL?
Example
Table - E.ECCCPRT
| Code: |
I_part
-------
001
002
.
.
.
100
|
Table - E.ESPMAST
| Code: |
I_part VOLUME_Demand part_Cost
------- ------------------- ------------
001 1 1
002 2 2
.
.
.
100 4 4
.
.
.
900 2 2
|
My output file should contain
| Code: |
001 1 1
002 2 2
.
.
.
100 4 4
|
|
|
| Back to top |
|
 |
Aaru
Senior Member
Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India
|
|
|
|
Hi,
| Quote: |
I have to extract only the primary key of th DB2 table into flat file.
|
Have you unloaded the tables into a flat files? Post the attributes of the files and their key positions.
| Quote: |
Is that possible thr JCL?
|
Yes, You can use the SPLICE operator of DFSORT for this requirement. Post the files if you want a working JCL for your requirement. |
|
| Back to top |
|
|
ibmmainframesyntel
Active User
Joined: 26 Feb 2007
Posts: 126
Location: Chennai
|
|
|
|
No, i have extract data from the DB2 table...
In this case,input is from DB2 table....... |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| ibmmainframesyntel wrote: |
No, i have extract data from the DB2 table...
In this case,input is from DB2 table....... |
So what is your question / problem ?
Moved to DB2 |
|
| Back to top |
|
|
ibmmainframesyntel
Active User
Joined: 26 Feb 2007
Posts: 126
Location: Chennai
|
|
|
|
Need a JCl for the above requirements..
Is that possible? |
|
| Back to top |
|
|
ibmmainframesyntel
Active User
Joined: 26 Feb 2007
Posts: 126
Location: Chennai
|
|
|
|
| I got it....which is in 'JCL' topic.... |
|
| Back to top |
|
|
|
|
