Is it good to do the above task using SYNCSORT or COBOL

kbmkris · Active User Joined: 24 Jun 2006 Posts: 101

Hi,

I am having a file with say n fields of which I have a field with a single alphabetic character. In the output file, I have to replace this alphabetic character with the corresponding number and with all the other fields remaining same. Could you please help me in doing this?

Moreover, my input file has millions of records. Whether it is good to do the above task using sort or COBOL program and which is efficient?

Thanks,
Bala

muthuvel · Posted: Thu May 31, 2007 10:50 am

If it is a single replacement for ex:whether it is "a" ,"b" or "c" you are going to replace by it one number say "5" then you can use sort with OUTREC option.
If it is a replacement of different numbers for different alphabets then COBOL is preferable.
In case of efficiency test both(COBOL and Sort) and see which consumes less CPU time or elapsed time.

kbmkris · Active User Joined: 24 Jun 2006 Posts: 101

Hi,

It is like replacing different alphabets with different numbers.
I would like to know whether this can be done by Syncsort. If so, could you let me know how to do that?

Thanks,
Bala

William Thompson · Posted: Thu May 31, 2007 2:31 pm

Like DFSort, Syncsort can convert characters. Look at the ALTSEQ and the TRAN parameters in your manual.

Anuj Dhawan · Posted: Thu May 31, 2007 8:44 pm

raak · Posted: Fri Jun 01, 2007 12:19 pm

Hey,

With Syncsort use this.

kbmkris · Active User Joined: 24 Jun 2006 Posts: 101

Hi anuj,

I have to do the same thing in a FB file and in a VB file also. Yes, I know the position of the character i want to change and the character will vary.
For e.g.
in my input file, if position 4 is
'C' then i have to change it to '1'.
'A' then to '2'.
'D' then to '3' like that.

Thanks,
Bala

William Thompson · Posted: Mon Jun 04, 2007 1:30 pm

You can translate more than one character at a time:
ALTSEQ CODE=(F0B7,F1B8,F2B9,F3BA,F4BB,F5BC,F6BD,F7BE,F8BF,F9C0)

Have you checked your manual?

kbmkris · Active User Joined: 24 Jun 2006 Posts: 101

hi William,

I am not sure how to formulate the corresponding hexcode for the alphabets. Please let me know how to find the corresponding hexcode for alphabets and numbers?

I went on checking with the previous Syncsort related posts in the forum and from that i came to know that some of the commands available in DFSORT will work in SYNCSORT also. I tried and it is working.

The code I used is

William Thompson · Posted: Mon Jun 04, 2007 2:39 pm

How many "IFTHEN" sort of substituions do you have? ONe for every letter in the alphabet? Or just a select few?

kbmkris · Active User Joined: 24 Jun 2006 Posts: 101

Hi William,

i have to do that based on some condition, say, if my position 7 and 8 of my input file contains TT and the character is C at position 9, i have to replace it to 1. Similarly i have to do for 8 conditions. So i have totally 8 ifthen in my sortcard. The full sortcard i used is

William Thompson · Posted: Mon Jun 04, 2007 3:05 pm

Looks like you got it, what's the problem?

kbmkris · Active User Joined: 24 Jun 2006 Posts: 101

Hi William,

My input file contains 90000000 records. I want to know what i have to use. I have a COBOL program to do the same without sorted output and this JCL. Which is efficient? Could you please suggest me?

Thanks,
bala

William Thompson · Posted: Mon Jun 04, 2007 4:26 pm

I'd say, it's pretty much your choice.....
If you already have the COBOL program, why not run both and see which id more efficient?

Anuj Dhawan · Posted: Wed Jun 06, 2007 8:38 pm

Hi Bala,

Sorry I was away from net for some days, so could not check your reply.

By the way, I hope you got your answer

.

kbmkris · Active User Joined: 24 Jun 2006 Posts: 101

hi Anuj,

Yes i got that. Thanks for your reply:-)

Anuj Dhawan · Posted: Thu Jun 07, 2007 7:41 pm

You are welcome.