SYNSORT JCL Required



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

SYNSORT JCL Required

Postby bharmf » Tue Jun 13, 2017 10:50 pm

Dear All,

Please find my requirement

InFile1
--------
length - 1045
REFM - VB
Key Field - 1 to 9
No duplicate records

Data looks like
============
111111111 aaaaaa bbbbbbbb
222222222 bbbbbb cccccccc
333333333 ccccccc aaaaaaaa
444444444 ccccccc aaaaaaaa

InFile2
--------
length - 1045
REFM - VB
Key Field - 1 to 9
No duplicate records

Data looks like
=============
111111111 aaaaaa bbbbbbbb
222222222 bbbbbb cccccccc
444444444 ccccccc aaaaaaaa

Outfile requirement
-------------------------
I want only key fields 9 bytes in the output record, not required any other fields of the matching records.

length - 80
REFM - FB

111111111
222222222
444444444

My workshop using SYNCSORT, Messages appearing as WER#### in spool from that I am saying we use SYNCSORT. Could You please help me on SORT card for this.

Thanks..!
bharmf
 
Posts: 6
Joined: Tue Jun 13, 2017 10:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYNSORT JCL Required

Postby prino » Tue Jun 13, 2017 11:08 pm

This is a ***HELP*** forum, not a "we do your work for you one"!

Usual price for a contractor to take over your job is about USD 100 per hour, usually with a minimum of eight hours.
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 635
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: SYNSORT JCL Required

Postby Akatsukami » Tue Jun 13, 2017 11:56 pm

Although I do not have Syncsort available to me, in DFSORT this would be a relatively simple JOINKEYS operation, and I have no reason to believe it is different in Syncsort. Where does your understanding fail?
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: SYNSORT JCL Required

Postby bharmf » Wed Jun 14, 2017 7:43 pm

Dear prino,

I requested for help, I do not know much about SORT utility basically. If You could help on that would be great help for me. My workshop using syncsort version 2.1.4

If my words would have appeared as hard. My apologize.
bharmf
 
Posts: 6
Joined: Tue Jun 13, 2017 10:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYNSORT JCL Required

Postby Robert Sample » Wed Jun 14, 2017 8:23 pm

bharmf, if people just give you the SORT statements then you have learned nothing (except to ask for help). If you take the hint you've been given and write your own JOINKEYS statements and try it out, then post if you don't get the results you want -- you will have actually learned how to do your own research (ALWAYS a good thing to know), how to use the SYNCSORT manuals, and how to use JOINJKEYS. It is far better for you to learn how to do these things because those who respond did the same thing (possibly many years ago) to learn what they now know.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: SYNSORT JCL Required

Postby bharmf » Wed Jun 14, 2017 10:31 pm

Thank You Robert Sample..! Right words..looked some sample posts and tried the below ...

SORT FIELDS = COPY
JOINKEYS FILES=FILE1,FIELDS=(5,13,A)
JOINKEYS FILES=FILE2,FIELDS=(5,13,A)
JOIN UNPAIRED,F1,F2,ONLY     --> Hope this will pick the unmatched records, I need to change this to select the only matched records.


First I tried to get ouput file as like same length 1045 VB as input file, to check how it works. Then planned to put the keywords
to make the output to 80 FB length.

Getting the below error.
-----------------------

WER268A JOIN KEYS STATEMENT: SYNTAX ERROR

SORT FIELDS = COPY
JOINKEYS FILES=FILE1,FIELDS=(5,13,A)
               *
JOINKEYS FILES=FILE2,FIELDS=(5,13,A)
               *
JOIN UNPAIRED,F1,F2,ONLY
             *

Message says whereever marked as * is the position on syntax error.
bharmf
 
Posts: 6
Joined: Tue Jun 13, 2017 10:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYNSORT JCL Required

Postby bharmf » Wed Jun 14, 2017 10:33 pm

Correction..

JOIN UNPAIRED,FILE1,FILE2,ONLY
bharmf
 
Posts: 6
Joined: Tue Jun 13, 2017 10:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYNSORT JCL Required

Postby Akatsukami » Wed Jun 14, 2017 10:51 pm

You have not shown your JCL. Are FILE1 and FILE2 the DDnames?
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times

Re: SYNSORT JCL Required

Postby bharmf » Wed Jun 14, 2017 11:03 pm

Yes Akatsukami..FILE1 and FILE2 are the DDnames.

Corection -
JOIN UNPAIRED,FILE1,FILE2,ONLY
bharmf
 
Posts: 6
Joined: Tue Jun 13, 2017 10:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYNSORT JCL Required

Postby NicC » Thu Jun 15, 2017 2:55 am

The way you posted your control statements meant that the error indicator (*) was below the first character of the statement instead of where the error was detected. This i one of the reasons why uou should use the code tags when posting data requiring a fixed pitch font i.e. anything on your 3270 screen. I have coded your post for you so we can now see where Syncsort believes the errors to be.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Next

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post