moved data is not in order.



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

moved data is not in order.

Postby supriya saraswat » Mon Jul 07, 2008 3:43 pm

i have moved unmatched records from 2 files to my output file...but the records are not in same order as it is in my input file.

file A contains record form position 1 to 20 and is of record length 20
file b contains other fields including that fileld which is present in file one but here its position is different from 20 to 39 and record length is 1396.

we have to move unmatched data from fileb to out out file

i have done it but it s not coming in ordered way.

can any one help me?
supriya saraswat
 
Posts: 21
Joined: Mon Jul 07, 2008 3:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: moved data is not in order.

 

Re: moved data is not in order.

Postby Frank Yaeger » Mon Jul 07, 2008 8:54 pm

How can we possibly help you when you haven't shown us your JCL, input, output, etc? We have no idea what functions you're using or what you're actually doing/trying to do.

Show an example of the records in your input files (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. If input file1 can have duplicates within it, show that in your example. If input file2 can have duplicates within it, show that in your example. Give the RECFM and LRECL of the input files. Give the starting position, length and format of all relevant fields.
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

Re: moved data is not in order.

Postby supriya saraswat » Tue Jul 08, 2008 12:49 pm

yah actually i got the answer...thanks for showing interest
supriya saraswat
 
Posts: 21
Joined: Mon Jul 07, 2008 3:24 pm
Has thanked: 0 time
Been thanked: 0 time

Re: moved data is not in order.

Postby Frank Yaeger » Tue Jul 08, 2008 8:38 pm

Good for you.
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