MVSFORUMS.com

kirankumar · Beginner Joined: 25 Oct 2005 Posts: 3 Topics: 1

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 .

kolusu · 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

kirankumar · Beginner Joined: 25 Oct 2005 Posts: 3 Topics: 1

DCB=(VB,404,27998)
file1.
4010045012060828946 BS6000510204010045012060828946
4010045012170252085 BS6000510205012170252085

file2.
412004501A490008958 BS250051021BPUP00000000000{000000
412004501A490017667 BS250051021BPUP00000000000{000000
file3.
010048703554082801 AS250051019DOCC00000000000{000000
010048705320701856 AS250051019DOCC00000000000{000000

kolusu · 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

kirankumar · Beginner Joined: 25 Oct 2005 Posts: 3 Topics: 1

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.

Phantom · 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

kolusu · 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

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

So whats the solution to this query...

Phantom · Posted: Mon Oct 31, 2005 2:12 am Post subject:

vkphani,

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

Hi Phantom,

I don't have any solution.
Probably Kolusu or Frank Yaeger will give the solution to this query.

kolusu · Posted: Wed Nov 02, 2005 5:11 am Post subject:

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

Kolusu,

Who is OP?

kolusu · Posted: Wed Nov 02, 2005 5:28 am Post subject:

OP = original Poster
_________________
Kolusu
www.linkedin.com/in/kolusu

vkphani · Intermediate Joined: 05 Sep 2003 Posts: 483 Topics: 48

You are true Kolusu.
OP is not providing any details even after a week of query submission.

Frank Yaeger · Posted: Wed Nov 02, 2005 11:17 am Post subject: