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

Stripping and Sorting of VB file


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
G SRINIVASA RAO

New User


Joined: 14 Sep 2016
Posts: 3
Location: INDIA

PostPosted: Wed Sep 14, 2016 1:34 pm
Reply with quote

Hi,

Could someone help me on error for the sort card where i am striping few columns and sorting 2 fields of I/P VB file(LRECL=2016) and writing to O/P VB file(LRECL=2004). And also file contains a trailer.

Sortcard:

Code:
OPTION VLSHRT
INREC IFTHEN=(WHEN=INIT,BUILD=(1,4,5:C'1',6:5)),
      IFTHEN=(WHEN=(6,7,CH,EQ,C'0000000'),OVERLAY=(5:C'9'))
SORT FIELDS=(5,1,CH,A,18,7,CH,A,32,5,CH,A)
OUTREC BUILD=(1,4,6:18,2000)



Error:

Code:
INREC RECORD LENGTH = 2017
POTENTIALLY INEFFICIENT USE OF INREC
OUTREC RECORD LENGTH = 2005



Thanks in advance..

Thanks!
Srinivas

Coded
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Wed Sep 14, 2016 3:40 pm
Reply with quote

What do you mean by'striping' (to add stripes) or do you mean 'stripping'?
Please show the whole message including the message identifier. There does not appear to be an error there but a warning. And, based on those 3 lines, what have you done to try and resolve it - apart from posting on a forum?
Back to top
View user's profile Send private message
G SRINIVASA RAO

New User


Joined: 14 Sep 2016
Posts: 3
Location: INDIA

PostPosted: Wed Sep 14, 2016 5:01 pm
Reply with quote

Hi Nic,

Its a typo. It is 'stripping'

Below code worked for me. removed record length from Outrec build.

Code:
OPTION VLSHRT
INREC IFTHEN=(WHEN=INIT,BUILD=(1,4,5:C'1',6:5)),
      IFTHEN=(WHEN=(6,7,CH,EQ,C'0000000'),OVERLAY=(5:C'9'))
SORT FIELDS=(5,1,CH,A,18,7,CH,A,32,5,CH,A)
OUTREC BUILD=(1,4,6:18)

Thanks!
Srinivas

Code'd
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Sep 14, 2016 5:07 pm
Reply with quote

I don't think the VLSHRT is giving you any benefit.

The warning was indeed caused by the erroneous 2000. However, it looks as though you could cut down further in INREC as there is data getting into the SORT which is not on the output records.
Back to top
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 2023
Location: USA

PostPosted: Wed Sep 14, 2016 11:18 pm
Reply with quote

G SRINIVASA RAO,

The right sequence of efforts should be:

1) read SYNCSORT manuals, and/or other related topics/forums
2) code the statements in accordance with clearly defined rules
3) try to run your job
4) analyze the error message(s); consult with the manuals; try to fix them
5) ask at the forum what you did wrong?

Actually what you're doing is the following

1) code whatever comes first to your mind
2) run the job you have no idea about
3) ask at the forum why something you don't understand is not working somehow you don't know how?
Back to top
View user's profile Send private message
G SRINIVASA RAO

New User


Joined: 14 Sep 2016
Posts: 3
Location: INDIA

PostPosted: Thu Sep 15, 2016 11:26 am
Reply with quote

Thanks Tyrannosaurus for your suggestion.

Only after trying all the options which you mentioned above I contacted the forum. In parallel I was trying to resolve the issue.
I have no intention to waste anyone's time.

thanks!
Srinivasa Rao
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 -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top