Posted: Fri Dec 22, 2006 4:04 am Post subject: join data earlier from a File with new contents
I have a File A with contents ABCD.I have one more step which executes SORT step and SORTOUT routes to File A with some output say PQRS.What happens is the contents of FILE A are overwritten if DISP=SHR is given and in the output i get PQRS.But i want in the output FILE A the original contents + blank (SPACE ) + new Sort step output .
For example i want the ouput as :
Code:
ABCD PQRS
in a single line not in two lines with (MOD concept).
Joined: 02 Dec 2002 Posts: 415 Topics: 6 Location: Hove, England
Posted: Fri Dec 22, 2006 6:02 am Post subject:
I think you need to post the code you are using. It obviously needs a small change, which would be fairly easy for a contributor to supply, but you can't expect to receive a complete solution starting from scratch. _________________ The day you stop learning the dinosaur becomes extinct
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Fri Dec 22, 2006 11:37 am Post subject:
yadav2005,
Sounds like you're trying to join fields from two records. The SPLICE technique discussed in the "Join fields from two files record-by-record" Smart DFSORT Trick at:
If you need more specific help, show the records in each input file and the record or records you expect for output. Give the starting position, length and format of the relevant fields. Give the RECFM and LRECL of the input files. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Initially File A is 160 bytes (LRECL and RECFM = FB) and it has data from position 1 - 4 value 'ABCD' and remaining blanks and has only 1 Record.Now the Sort Step produces new output 'PQRS' in position 1 - 4 and File A has now data as 'PQRS' and has only 1 record.But i want the output in File A as starting from Pos 1.
_________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
In first step i am generating File A from another File say X which will always produce a single record say 'ABCD' in pos 1 - 4
In second step File A is again being used to generate a output from a File say Y and it will always produce a single record say 'PQRS' in pos 1 - 4.In either of the steps FILE A is the output.What i want in the output FILE A is
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Fri Dec 22, 2006 3:44 pm Post subject:
I don't know how you're "generating" these records. Are you using DFSORT or some other utility? What do the generating steps look like? If you want to use FileA as the only output file for both generating steps, then you need to change the generating steps to do what you want.
If you want to use DFSORT for this, then you can have your generating steps put the two generated records in a temp data set (use MOD for the temp data set) and then use the temp data set as input to the following DFSORT/ICETOOL job to get the output record you want in FileA:
You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use INREC with SPLICE. If you don't have April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see:
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum