View previous topic :: View next topic
|
Author |
Message |
advith001
New User
Joined: 16 Mar 2005 Posts: 23
|
|
|
|
I required to write the output record having 2 columns, one from first file say file1 and another from second file file2 by using JCL. not COBOL code.
file1 having fldA fldB fldC
file2 having fldD fldE
outfile should have fldB and fldE
Please help me on this request. |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You need to give more detail. What is the RECFM and LRECL of each input file? Does each input file have only one record or many records? If many records, then do you want to "join" the fields from record 1 of file1 with record 1 of file2, record 2 of file1 with record 2 of file2, etc, or do you want to "join" the fields on a common key? What is the position, length of format of each relevent field?
Showing an example of records with actual values for input file1 and input file2 and what you want the output records to look like would help clarify what you need. |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
Back to top |
|
|
advith001
New User
Joined: 16 Mar 2005 Posts: 23
|
|
|
|
Dear all,
thankx i got solution for my requirement.
I apologize for the confusion.
My requrement is
FILE1
FLDA1 FLDA2 FLDA3
101 NameA1 LOCA1
102 NameA2 LOCA2
103 NameA3 LOCA3
104 NameA4 LOCA4
105 NameA5 LOCA1
106 NameA6 LOCA2
107 NameA7 LOCA3
108 NameA8 LOCA4
FILE2
FLDB1 FLDB2
102 NameA2
103 NameA3
105 NameA5
107 NameA7
109 NameA9
OUTFILE
FLDO1 FLDO2
102 NameA2
103 NameA3
105 NameA5
107 NameA7
Thanks,
Anna. |
|
Back to top |
|
|
ssowjanya
New User
Joined: 29 Apr 2005 Posts: 13
|
|
|
|
Hi Advith,
Can u explain how u solved ur problem.
thank u |
|
Back to top |
|
|
asridhar
New User
Joined: 04 May 2005 Posts: 5 Location: Hyderabad
|
|
|
|
can you explain whats the complete jcl for this one |
|
Back to top |
|
|
|