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
 

 

Stripping and Sorting of VB file

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
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    Post subject: Stripping and Sorting of VB file
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: 1715
Location: UK

PostPosted: Wed Sep 14, 2016 3:40 pm    Post subject:
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    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7234

PostPosted: Wed Sep 14, 2016 5:07 pm    Post subject: Reply to: Stripping and Sorting of VB file
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

New User


Joined: 29 Apr 2008
Posts: 37
Location: Maryland

PostPosted: Wed Sep 14, 2016 11:18 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts CICS Roll back partially - Need to re... dwijadas CICS 4 Wed Nov 16, 2016 4:30 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm


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