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

VB file sorting


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
V S Amarendra Reddy

Active User


Joined: 13 Sep 2006
Posts: 216
Location: USA

PostPosted: Fri Feb 26, 2016 8:29 pm
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: 446
Location: USA

PostPosted: Fri Feb 26, 2016 10:07 pm
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: 216
Location: USA

PostPosted: Fri Feb 26, 2016 11:09 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts COBOL Table data to a flat file with ... COBOL Programming 5
No new posts Compare 2 files replace data in 1st f... DFSORT/ICETOOL 4
No new posts Merging 2 files but ignore duplicate... DFSORT/ICETOOL 1
No new posts DB2 SQL query to read and update data... DB2 12
This topic is locked: you cannot edit posts or make replies. copy file 2 data into file1 for match... DFSORT/ICETOOL 4
Search our Forums:

Back to Top