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
 

 

Syncsort - Changing blank characters to LOWVALUES

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Fri Jan 14, 2011 1:03 pm    Post subject: Syncsort - Changing blank characters to LOWVALUES
Reply with quote

Hi,

I have a file. Which has blank lines (entire record is having SPACE chars). I have to replace the blank chars with LOWVALUES only for the blank record. Spaces present at the end of the other records should not get changed. We have Syncsort in our shop.

I tried the following but couldn't able to achieve the results. Any lead in this regard will be a great help.

SORT FIELDS=COPY
OUTREC IFTHEN=(WHEN=(1,160,CH,EQ,X'40'),
OVERLAY=(1:X'00'))

Job is giving return code as 00 but nothing is getting converted.

SORT FIELDS=COPY
ALTSEQ CODE=(4000)
OUTREC FIELDS=(1,160,TRAN=ALTSEQ)

Job is converting all the SPACES in the file to LOW-VALUES.

Record length is 160.

Example data:
Input:
12321 34

23434234
34 43456

If we open the file in HEX ON then we can see spaces(x'40') in second chars
Output:
12321 34

23434234
34 43456
Only second record in the file should have LOW-VALUES (X'00').
Space in 1st and 4th record should not get converted.
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2284
Location: @my desk

PostPosted: Fri Jan 14, 2011 11:01 pm    Post subject:
Reply with quote

mallik4u,

This is untested, but I believe modifying your sort card like this should solve your problem.
Code:
  SORT FIELDS=COPY
  OUTREC IFTHEN=(WHEN=(1,160,CH,EQ,C' '),
         OVERLAY=(1:160Z))
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Jan 18, 2011 9:49 pm    Post subject:
Reply with quote

Arun Raj wrote:
This is untested, but I believe modifying your sort card like this should solve your problem.
Yes, your solution will work.
Back to top
View user's profile Send private message
mallik4u

New User


Joined: 17 Sep 2008
Posts: 75
Location: bangalore

PostPosted: Wed Jan 19, 2011 10:42 am    Post subject: Reply to: Syncsort - Changing blank characters to LOWVALUES
Reply with quote

Thank you very much.
That solved my problem.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2284
Location: @my desk

PostPosted: Wed Jan 19, 2011 11:36 am    Post subject:
Reply with quote

Mallik,

You're welcome. Thanks for letting us know
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts BI,TO=ZD Changing Values Tyler Dunbar DFSORT/ICETOOL 4 Tue Jul 25, 2017 12:12 am
No new posts Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts Remove junk values in a file and rite... KP1125 DFSORT/ICETOOL 2 Wed Jan 25, 2017 9:58 pm
No new posts SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 7 Sat Jan 21, 2017 4:02 am
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am


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