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
 

 

VB file sorting

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
V S Amarendra Reddy

Active User


Joined: 13 Sep 2006
Posts: 189
Location: INDIA

PostPosted: Fri Feb 26, 2016 8:29 pm    Post subject: VB file sorting
Reply with quote

Input file:VBA, record length=240
Code:

 DSNT490I SAMPLE DATA UNLOAD PROGRAM                                           
 DSNT505I DSNTIAUL OPTIONS USED: SQL                                           
 DSNT503I UNLOAD DATA SET SYSPUNCH RECORD LENGTH SET TO    80                   
 DSNT504I UNLOAD DATA SET SYSPUNCH BLOCK SIZE SET TO 27920                     
 DSNT506I INPUT STATEMENT WAS NOT A FULL SELECT ON A SINGLE TABLE. LOAD STATEMEN
 DSNT503I UNLOAD DATA SET SYSREC00 REC456 LENGTH SET TO   269                   
 DSNT504I UNLOAD DATA SET SYSREC00 BLOCK SIZE SET TO 27976                     
 DSNT495I SUCCESSFUL UNLOAD            1 ROWS OF TABLE TBLNAME                 
 DSNT506I INPUT STATEMENT WAS NOT A FULL SELECT ON A SINGLE TABLE. LOAD STATEMEN
 DSNT503I UNLOAD DATA SET SYSREC01 REC786 LENGTH SET TO   526                   
 DSNT504I UNLOAD DATA SET SYSREC01 BLOCK SIZE SET TO 27878                     
 DSNT495I SUCCESSFUL UNLOAD            5 ROWS OF TABLE TBLNAME                 


Sort control card I am using is

Code:

OPTION COPY,VLSHRT                                   
INCLUDE COND=(38,6,SS,EQ,C'00 REC,01 REC')           
SORT FIELDS=(44,3,ZD,D)                             
OUTFIL BUILD=(34,7,64,4,UFF,EDIT=(TTTT),80:X),CONVERT


I am trying to sort the records with the strings REC456, REC786 that are in byte 44(that includes RDW).

Current Output
Code:

REC00 0269
REC01 0526


Expected Output
Code:

REC01 0526
REC00 0269


What is the mistake in the control card?

Regards
Amar
Back to top
View user's profile Send private message

RahulG31

Active User


Joined: 20 Dec 2014
Posts: 361
Location: USA

PostPosted: Fri Feb 26, 2016 10:07 pm    Post subject: Reply to: VB file sorting
Reply with quote

Remove
Code:
OPTION COPY

Quote:
The sort statement is ignored because the COPY option has been specified.


.
Back to top
View user's profile Send private message
V S Amarendra Reddy

Active User


Joined: 13 Sep 2006
Posts: 189
Location: INDIA

PostPosted: Fri Feb 26, 2016 11:09 pm    Post subject:
Reply with quote

Sometimes the answer is right in front of the face and can't notice it. icon_biggrin.gif I was doing lot of permutations and combinations and didn't notice this.

Thank you for highlighting and it worked. icon_smile.gif
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Length of Tape file Mohan Kothakota JCL & VSAM 9 Thu Apr 20, 2017 10:24 pm
No new posts Need help in reading and validating a... ABINAYATHULASI COBOL Programming 8 Tue Apr 18, 2017 11:42 am
No new posts Validating file with multiple header/... mohitsaini DFSORT/ICETOOL 6 Thu Apr 13, 2017 1:53 am
This topic is locked: you cannot edit posts or make replies. Need help in estimating space of unlo... ashek15 IMS DB/DC 12 Fri Apr 07, 2017 5:11 am


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