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
 

 

Sort to make remaining 10 bytes be blank

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

New User


Joined: 19 Feb 2005
Posts: 6

PostPosted: Thu Mar 06, 2008 5:30 pm    Post subject: Sort to make remaining 10 bytes be blank
Reply with quote

I have the input file of 200 bytes VB, but the records are 190 bytes, so the remaing 10 bytes should be blank (not spaces).

Please find the examples with HEX ON below.

example:
Input file:
Code:

+----8----+----9----+----0-
ANT TRAVEL                 
CDE4EDCECD4444444444
153039155300000000000   


output fule:
Code:

+----8----+----9----+----0
ANT TRAVEL                 
CDE4EDCECD44
15303915530000   

KITCHENS PLC   
DCECCCDE4DDC444
29338552073300000


The remaing 10 bytes sholud be blank (it is not an spaces).
Can we do it using SORT.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Thu Mar 06, 2008 5:42 pm    Post subject: Reply to: Help in sort.
Reply with quote

for a variable record, the lrecl is the maximum record length expected,

for a layout consistent with the VB definition, the trailing blanks/spaces should not be there
if You expect every record to be filled up with blanks/spaces up to the maximum length
there is no reason of having the overhead of VB record format
and You should change a little bit Your terminology and/or Your view of things
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu Mar 06, 2008 10:10 pm    Post subject:
Reply with quote

mramesh,

I can't figure out what you want to do. Blank/space are the same thing (X'40'). And as enrico points out, VB records usually don't have trailing blanks (although they can).

You're going to have to do a better job of explaining clearly what you want do before anyone can help you.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Thu Mar 06, 2008 10:26 pm    Post subject:
Reply with quote

Looks like the program that is producing the records is not setting the length properly before writing them!
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
No new posts SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


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