this is the scenario



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

this is the scenario

Postby shiva5977 » Fri Jul 23, 2010 7:49 pm

this is shiva now i provided sample data go through that

file1 file2
sno: sno:
1 1
2 2
3 3
4 4
1
1
4
4
3
3

now my query is i want to copy matching records to file3 and duplicate records from file1 to file4

can any one help me......with logic
shiva5977
 
Posts: 2
Joined: Sat May 01, 2010 7:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: this is the scenario

 

Re: this is the scenario

Postby Frank Yaeger » Fri Jul 23, 2010 9:20 pm

now my query is i want to copy matching records to file3 and duplicate records from file1 to file4


It's not clear what you mean by this. Please show the output you expect for this input example and explain the rules for getting from input to output. Give the RECFM and LRECL of each input file. Give the starting position, length and format of each relevant field.

I'm guessing your input records don't really look like that. It would be better to show what your input records actually look like and what you expect for output.

Also, run this job and show the //SYSOUT messages you receive, so I can see what level you're at:

//S1    EXEC  PGM=SORT
//SYSOUT    DD  SYSOUT=*
//SORTIN DD *
RECORD
//SORTOUT DD DUMMY
//SYSIN    DD    *
    OPTION COPY
/*
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: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post