Insert a new record based on a condition



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

Insert a new record based on a condition

Postby Gemini_1977 » Tue Mar 01, 2011 10:35 pm

Hi,

I have an input file

123AAA -->key
345BBB -->key
678CCC -->key

Now I need to insert a new record if a given key is not present

output file

123AAA
345BBB
678CCC
890DDD --> new record is inserted since 'DDD' is not present in the input file......

Can someone please give me the DFSORT

Thanks
Mahesh
Gemini_1977
 
Posts: 1
Joined: Tue Mar 01, 2011 10:20 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Insert a new record based on a condition

 

Re: Insert a new record based on a condition

Postby skolusu » Tue Mar 01, 2011 10:57 pm

Gemini_1977,

Didn't you post the same question on other board as syncsort user? DFSORT and Syncsort are competitive products. we are happy to answer questions on DFSORT and DFSORT's ICETOOL, but we don't answer questions on Syncsort.

Thanks
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post