IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SYNCSORT: SORTIN Lrecl 138 but SORTOUT is 134


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
morpheus007

New User


Joined: 27 Dec 2005
Posts: 58

PostPosted: Tue Apr 03, 2007 4:27 pm
Reply with quote

Kindly have a look at this SYSIN for SYNCSORT:

OPTION COPY
OUTREC FIELDS=(5,133),CONVERT
OMIT COND=((5,25,CH,EQ,C' '),OR,
(6,12,CH,EQ,C'------------'),OR,
(5,1,CH,EQ,C'1'),OR,
(5,1,CH,EQ,C'0'),OR,
(10,4,CH,EQ,C'NAME'),OR,
(6,4,CH,EQ,C'PAT.'))

The SORTIN file of this is 138 in lrecl and the SORTOUT is 134.

The input data is highly unstructured and hence I am not able to guess what this sortcard is doing.

If you could kindly give the logic as to what this sortcard will do it would be a great help.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Tue Apr 03, 2007 4:36 pm
Reply with quote

What do you think it is doing ?

What do you think OMIT COND= does ?

Have you taken a look in the fine manual to get some clues ?
Back to top
View user's profile Send private message
morpheus007

New User


Joined: 27 Dec 2005
Posts: 58

PostPosted: Tue Apr 03, 2007 5:25 pm
Reply with quote

Hi Expat,

Kindly paste the link for a 'FINE MANUAL' on SYNCSORT only(Not DFSORT) and I will appologise for my ignorance and discover the truth for myself.

You are a senior member.I respect that and that is the reason I am avoiding an argument here.Kindly avoid replying in a manner(with questions???) that might spark a return argument from someone less patient than me.It will not help the forum.

I am here assuming there are people more knowledgable and with a little PATIENCE too in the forum.And by the way your questions did not help me too much.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Tue Apr 03, 2007 5:56 pm
Reply with quote

Hi there,

Please find the description of your sort card

Code:
OPTION COPY:
Use for copy
Code:
OUTREC FIELDS=(5,133)
mean to build the output record by taking 133 bytes of input record starting from 5th BYte
Code:
CONVERT :
Used for VB to FB conversion
Code:
OMIT COND=((5,25,CH,EQ,C' '),OR,
(6,12,CH,EQ,C'------------'),OR,
(5,1,CH,EQ,C'1'),OR,
(5,1,CH,EQ,C'0'),OR,
(10,4,CH,EQ,C'NAME'),OR,
(6,4,CH,EQ,C'PAT.'))

:Used to exclude record from output if 5th byte is equal to spaces or from 6th byte to 18th byte is equal to '-' or if 5th byte is equal to 1 or 0 or if 10 to 13th byte conatin NAME OR 6th to 10th byte contain
'PAT.'.

Hope it will helpful
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Tue Apr 03, 2007 6:40 pm
Reply with quote

morpheus007 wrote:

Kindly paste the link for a 'FINE MANUAL' on SYNCSORT only(Not DFSORT) and I will appologise for my ignorance and discover the truth for myself.

You are a senior member.I respect that and that is the reason I am avoiding an argument here.Kindly avoid replying in a manner(with questions???) that might spark a return argument from someone less patient than me.It will not help the forum.

I am here assuming there are people more knowledgable and with a little PATIENCE too in the forum.And by the way your questions did not help me too much.


I am not a user of SYNCSORT so can not post the link for you. However, I do know where the manuals are for the products that I use.

The manner in which I replied is an attempt to get you to find a way to answer your own questions. In my opinion this is the best way to learn, to know where the documentation is, and also to try things that you read about in said manual.

As for patience, I am very patient - just a little brusque at times icon_biggrin.gif
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Apr 03, 2007 9:17 pm
Reply with quote

Hello,

The Syncsort documentation is available (free) from Syncsort, Inc for licensed users. It is copyright material and may not be linked to here in the forum.

If you run a small test using 10 or 20 input records, you can look at your input and the output and "back into" what the sort control cards are telling the sort to do. Hint: make sure that at least one of your test records has NAME beginning in position 10 for a length of 4. . .

If you look at your files, you may see that your input is variable length and the output is fixed.

When posting this type of question, it is a good idea to post the jcl as well adn the control statements. When posting jcl or control statements, it is more readable if you post using the "Code" tab at the top of the reply panel. You can also click "Preview" to see what you post will look like once submitted.

We're here if you have questions.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts VB to FB - Finding LRECL SYNCSORT 4
No new posts SORT deletes the SORTOUT file DFSORT/ICETOOL 8
No new posts Count Records with a crietaria in a f... DFSORT/ICETOOL 5
No new posts DFSORT/SYNCSORT/ICETOOL JCL & VSAM 8
Search our Forums:

Back to Top