|
View previous topic :: View next topic
|
| Author |
Message |
knobi
New User
Joined: 16 Aug 2005
Posts: 54
|
|
|
|
I have a file with one record (date & time), FB 15, and i would like to add this record to left side of all entries from another file.
Could someone suggest some DFSort way to do that, please ? Thanks |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Generate one or more DFSORT Symbols from the single-record file. Use the symbols thus generated everywhere you need them. |
|
| Back to top |
|
|
knobi
New User
Joined: 16 Aug 2005
Posts: 54
|
|
|
|
i'm trying to use JOINKEYS and REFORMAT ...
but i'm getting rc=20 |
|
| Back to top |
|
|
knobi
New User
Joined: 16 Aug 2005
Posts: 54
|
|
|
|
| not sure if JOINKEYS and REFORMAT works when the amount of records on both files are different .. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Show your sysout. In the Code tags. We can't just guess what you've got.
JOINKEYS is a big hammer in this case, and you only have a little nut to crack, but it will work. |
|
| Back to top |
|
|
Pandora-Box
Global Moderator
.jpg)
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
If are facing error you need to show us the SYSOUT
Can you show us the job and the sysout withing code tags? |
|
| Back to top |
|
|
knobi
New User
Joined: 16 Aug 2005
Posts: 54
|
|
|
|
i was doing wrong with the JOINKEYS.. that's why i was getting this error...
ICE405A 0 JOINKEYS STATEMENTS HAD MISMATCH IN NUMBER, LENGTH OR ORDER OF KEYS..... anyway i have changed the JCL some times since the error... and so far nothing ..
if anyone could point me to an example of ICETOOL using JOINKEYS where there is only one record in the first file (FB80), several records on the second one (FB80)..... and they successfuly put the content of the first file before each record of the second one.. i would appreciate... |
|
| Back to top |
|
|
knobi
New User
Joined: 16 Aug 2005
Posts: 54
|
|
| Back to top |
|
|
wiprov
New User
Joined: 13 Feb 2008
Posts: 15
Location: Chennai
|
|
|
|
| Could you please share your code? |
|
| Back to top |
|
|
|
|
