MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Syncsort. Doubt on how to use the "sort fields" pa

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
prog_mario
Beginner


Joined: 08 Sep 2007
Posts: 86
Topics: 27

PostPosted: Sun May 16, 2010 10:09 am    Post subject: Syncsort. Doubt on how to use the "sort fields" pa Reply with quote

Here's my code:

JOINKEYS FILE=F1,FIELDS=(001,011,A) item 1
JOINKEYS FILE=F2,FIELDS=(006,011,A) item 2
REFORMAT FIELDS=(F1:001,011,
F1:070,015,
F2:001,005,
F2:017,005,
F2:022,010)
SORT FIELDS=(001,011,A) item 3

The item words are used here only to identify the lines in which I need help.
Item 1 and 2 will be used by Syncsort just for comparison or also to sort my input files?

Item 3 will be used to sort the input files before data processing or to sort my output file?

I was also testing it in descending order using
SORT FIELDS=(001,011,A,D)
but I got an error. Could you tell me what's the right way to do it?

Thanks everybody.
Back to top
View user's profile Send private message
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Sun May 16, 2010 10:17 am    Post subject: Reply with quote

it would help your process of acquisition of information by reading a manual.
that would explain the syntax of the parameters and what they represent.

you don't want to tell anyone anything except 'but i got an error'.
that is useless. error are rather explicit; they tell a user what is/went wrong.
look it up or wait for someone to either take pity or display their knowledge and provide you with an answer.
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
prog_mario
Beginner


Joined: 08 Sep 2007
Posts: 86
Topics: 27

PostPosted: Sun May 16, 2010 10:26 am    Post subject: Reply with quote

Yes dbzTHEdinosauer, but unfortunately I don't have a Syncsort manual and I also couln't find one at internet. So I think I'll have to count on the answers to this post.
_________________
The more I learn, the more I want to learn.
Back to top
View user's profile Send private message
prog_mario
Beginner


Joined: 08 Sep 2007
Posts: 86
Topics: 27

PostPosted: Sun May 16, 2010 11:30 am    Post subject: Reply with quote

Thanks a lot everybody but I've already found the answers.
Items 1 and 2 will be used for sorting and comparing the information.
Item 3, the correct syntax is SORT FIELDS=(001,011,CH,D) and it will sort my output file using the reformated fields.
Thanks again.
_________________
The more I learn, the more I want to learn.
Back to top
View user's profile Send private message
papadi
Supermod


Joined: 20 Oct 2009
Posts: 594
Topics: 1

PostPosted: Sun May 16, 2010 4:38 pm    Post subject: Reply with quote

Good to hear it is working - thanks for the update.

When you have an error, you need to post the diagnostic information (including all message ids) generated by the run.

As DBZ said - posting "it didn't work" is a complete waste of everyone's time.
_________________
All the best,

di
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group