Building one output file from two input files



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: Building one output file from two input files

Postby dick scherrer » Tue Aug 24, 2010 11:24 pm

Hello,

Dick, I did use the preview but I guess I misunderstood the "Code" tag thing.
If the "Preview" looks like you want, then Submit. It the preview is not exactly what you want, make changes and preview again.

If Submit is not clicked, the work will be lost when you move away from that page. . . And there is no warning - it is just "gone:" ;)
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: Building one output file from two input files

Postby Frank Yaeger » Wed Aug 25, 2010 2:36 am

I'll have to try and find some more information about the Temp area, I thought I could use it as an area to build the records but I guess not.


I don't know what you mean by "the Temp area". DFSORT doesn't have one. A common technique with DFSORT is to add fields temporarily after the end of your records and then remove them. But we don't call that a "Temp area".
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: Building one output file from two input files

Postby IRHamilton » Thu Aug 26, 2010 1:55 am

Frank Yaeger wrote:
I'll have to try and find some more information about the Temp area, I thought I could use it as an area to build the records but I guess not.


I don't know what you mean by "the Temp area". DFSORT doesn't have one. A common technique with DFSORT is to add fields temporarily after the end of your records and then remove them. But we don't call that a "Temp area".
My apologies, beginner messing up.

What I'm calling the temp area, which I guess is wrong, is when you copy records to temp storage . . .

COPY FROM(INFL) TO(TEMP1) USING(CTL1)

I thought I could build records, field by field, using this area but it didn't work out in this case. Lack of knowledge.

Thanks again for your help.
IRHamilton
 
Posts: 6
Joined: Mon Aug 23, 2010 2:53 am
Has thanked: 0 time
Been thanked: 0 time

Re: Building one output file from two input files

Postby Frank Yaeger » Thu Aug 26, 2010 3:09 am

FYI, TEMP1 is referred to as a "temporary data set" meaning it is just needed for the step and not kept permanently. "temp area" would imply a temporary storage area.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post