| View previous topic :: View next topic |
| Author |
Message |
lacoe1
Beginner
Joined: 24 Feb 2005
Posts: 33
Topics: 17
|
 Posted: Tue May 09, 2006 3:16 am Post subject: Replace binary data with spaces |
 |
|
I am getting binary data in my output file as below
10199 ..5922100....01/05/2004..1480.31........4576.00........283.71.....
How do I replace them with spaces using SORT? |
|
| Back to top |
|
 |
hariavinash
Beginner
Joined: 21 Jan 2005
Posts: 52
Topics: 7
|
| Posted: Tue May 09, 2006 5:51 am Post subject: |
|
|
lacoe1,
Is the data position same for all the records with binary data.
cheers |
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Tue May 09, 2006 11:01 am Post subject: |
|
|
You haven't given enough information for anyone to help you. You need to give more details and explain clearly what you're trying to do.
What do you mean by binary data? It's hard to understand how '01/05/2004' can be "binary" data rather than "character" data. If the value is X'F0F160F0F560F2F0F0F4', then it is character data. If that's not what the value looks like in hex, then what does it look like in hex?
What is the position, length and format of each field you want to replace with spaces? Do you want to put spaces in these positions regardless of what's in them, or do you only want to replace specific values with spaces? What are the rules?
What is the RECFM and LRECL of your input file.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
