View previous topic :: View next topic |
Author |
Message |
kirankumar Beginner
Joined: 25 Oct 2005 Posts: 3 Topics: 1
|
Posted: Tue Oct 25, 2005 11:38 am Post subject: sort card |
|
|
I had a requirement to sort only two records with same transcode at position 29 with out distrubing the file with other transactions
I want a condition in such a way that when ever the 600 transaction comes with account num and loccode and the same transaction with only account number.the record with only account number should swap up with out changing the format of the file..
Here is my sort card
sort fields=(05,19,ch,a)
This sholud remain same and i want a condition for the above . |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Tue Oct 25, 2005 11:49 am Post subject: |
|
|
kirankumar,
Please post a sample input and desired output along with the DCB properties of files.
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
kirankumar Beginner
Joined: 25 Oct 2005 Posts: 3 Topics: 1
|
Posted: Tue Oct 25, 2005 12:06 pm Post subject: |
|
|
DCB=(VB,404,27998)
file1.
4010045012060828946 BS6000510204010045012060828946
4010045012170252085 BS6000510205012170252085
file2.
412004501A490008958 BS250051021BPUP00000000000{000000
412004501A490017667 BS250051021BPUP00000000000{000000
file3.
010048703554082801 AS250051019DOCC00000000000{000000
010048705320701856 AS250051019DOCC00000000000{000000 |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Tue Oct 25, 2005 12:17 pm Post subject: |
|
|
kiran kumar,
Your sample input is like greek and latin to me. what am I looking at ? what is it with 3 files ? which file is input and which file is the output?
Post detailed information on what you're trying to accomplish. Do not make people guess what you mean. This will give you a much better chance of getting a good answer to your question.
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
kirankumar Beginner
Joined: 25 Oct 2005 Posts: 3 Topics: 1
|
Posted: Wed Oct 26, 2005 6:44 am Post subject: |
|
|
The input file is a VB
Input file
422099 100051025750000000000000000000000000000000000000
432099 100051025750000000000000000000000000000000000000
4020045012211833307 AS6000510254020045012211833307
4020045012211833307 AS6000510255012211833307
4020045012210070588 AS6000510255012210070588
4010045012210315885 BS6000510255012210315885
Desired output
422099 100051025750000000000000000000000000000000000000
432099 100051025750000000000000000000000000000000000000
4020045012211833307 AS6000510255012211833307
4020045012211833307 AS6000510254020045012211833307
4020045012210070588 AS6000510255012210070588
4010045012210315885 BS6000510255012210315885
With sort card having a combination of sort fields=(05,19,ch,a) and which swaps the 3rd and 4th records. |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Wed Oct 26, 2005 7:11 am Post subject: |
|
|
KiranKumar,
I don't understand that why you are so adament on not providing clear and complete information. You are sitting in some remote place and no body here can read whatz in on your mind.
Where is your account number and loc-code. What is stored in the bytes 5-23 which you are trying to sort. You initially gave three files and now you come up with just two (one input and one output).
Unless you give us Clear information, nobody can help you out.
Thanks,
Phantom |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
Posted: Thu Oct 27, 2005 4:51 am Post subject: |
|
|
kirankumar,
you are just wasting your time. I deleted your 2 other posts which discusses the same question.
Thanks
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
vkphani Intermediate
Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
Posted: Fri Oct 28, 2005 6:30 am Post subject: |
|
|
So whats the solution to this query... |
|
Back to top |
|
|
Phantom Data Mgmt Moderator
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Mon Oct 31, 2005 2:12 am Post subject: |
|
|
vkphani,
Quote: |
So whats the solution to this query...
|
We don't understand on what needs to be done, from whatever information he has given. So, we can't provide any solutions unless he comes out with complete and clear information.
If you have any solution, please feel free to post. I would appreciate that.
Thanks,
Phantom |
|
Back to top |
|
|
vkphani Intermediate
Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
Posted: Wed Nov 02, 2005 3:52 am Post subject: |
|
|
Hi Phantom,
I don't have any solution.
Probably Kolusu or Frank Yaeger will give the solution to this query. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
vkphani Intermediate
Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
Posted: Wed Nov 02, 2005 5:25 am Post subject: |
|
|
Kolusu,
Who is OP? |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12372 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
vkphani Intermediate
Joined: 05 Sep 2003 Posts: 483 Topics: 48
|
Posted: Wed Nov 02, 2005 5:56 am Post subject: |
|
|
You are true Kolusu.
OP is not providing any details even after a week of query submission. |
|
Back to top |
|
|
Frank Yaeger Sort Forum Moderator
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
Posted: Wed Nov 02, 2005 11:17 am Post subject: |
|
|
Quote: | I beleive Frank is also with me unless his crystal ball can read OP's mind |
Nope, my crystal ball and the tea leaves aren't giving me anything on this one. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
Back to top |
|
|
|
|