Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SYNCSORT: SORTIN Lrecl 138 but SORTOUT is 134

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: SYNCSORT: SORTIN Lrecl 138 but SORTOUT is 134
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: 8593
Location: Back in jolly old England

PostPosted: Tue Apr 03, 2007 4:36 pm    Post subject:
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    Post subject: Re: SYNCSORT SYSIN
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: 1187
Location: Bangalore,India

PostPosted: Tue Apr 03, 2007 5:56 pm    Post subject:
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: 8593
Location: Back in jolly old England

PostPosted: Tue Apr 03, 2007 6:40 pm    Post subject: Re: SYNCSORT SYSIN
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

Site Director


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

PostPosted: Tue Apr 03, 2007 9:17 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts Can you write 2 recs on SORTOUT when ... Sysaron DFSORT/ICETOOL 6 Thu Feb 23, 2017 12:07 am
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us