Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 10309
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 Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm
No new posts Error in SQL-PLIST3 'Above value tru... rikdeb DB2 4 Wed Sep 06, 2017 1:34 pm
No new posts SORT Trailer Count - LRECL Output co... amorante DFSORT/ICETOOL 5 Tue Aug 29, 2017 8:57 pm
No new posts Changing sort Card Dynamically vickey_dw DFSORT/ICETOOL 5 Sat Aug 19, 2017 2:33 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us