Updating Record1 based on Record2 in the same file.



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

Updating Record1 based on Record2 in the same file.

Postby shiitiizz » Thu Dec 06, 2012 6:37 pm

Hi All,

I have one file which has got records at first two lines as below

Line 1: 1 to 46 Col is => DATADATADATADATADATADATADATADADATADATADATADATA
Line 2: 47 to 50 Col is => 0002

I need to append 47th Col of Line 1 with the value present in 47th Col of Line 2 and rest of the lines can remain as it is, output will be like
Line 1: DATADATADATADATADATADATADATADADATADATADATADATA0002

Kindly assist to get this in SORT.
shiitiizz
 
Posts: 16
Joined: Thu Dec 06, 2012 2:30 pm
Has thanked: 3 times
Been thanked: 0 time

Re: Updating Record1 based on Record2 in the same file.

Postby dick scherrer » Fri Dec 07, 2012 12:58 am

Hello,

What have you tried? What happened?
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: Updating Record1 based on Record2 in the same file.

Postby skolusu » Fri Dec 07, 2012 3:20 am

Is this the same request you send me via Private message? The Private message talks about 2 different files and here you have just 1 file. which requirement is the real one?
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

Re: Updating Record1 based on Record2 in the same file.

Postby shiitiizz » Fri Dec 07, 2012 7:08 am

Hi Kolusu,

I am extremely Thankful for your help..its the similar request to the one I sent in PM but here we have a single file.
Is there a way to read Line 2 record of a file and update Line 1 record using SORT...

Regards
shiitiizz
 
Posts: 16
Joined: Thu Dec 06, 2012 2:30 pm
Has thanked: 3 times
Been thanked: 0 time

Re: Updating Record1 based on Record2 in the same file.

Postby BillyBoyo » Fri Dec 07, 2012 3:34 pm

Sending PMs, making public solicitations, are both "bad form", a mis-use of people's time. To us, the importance of your task is of no real interest. It is something that you/your organisation should have thought about and planned for much earlier. If you have something you are "keen" to see done at short notice, locate someone (even here :-) ) who can do it, and pay them.

Any good effects of your effusiveness are not long-lasting, by the way.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post