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
 

 

Removing Spaces with SORT

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

New User


Joined: 21 Nov 2006
Posts: 50
Location: India

PostPosted: Wed Mar 05, 2008 11:01 pm    Post subject: Removing Spaces with SORT
Reply with quote

Hi,

I have the Records like this

Code:

AAAAAAAAA   B
XXXXXXX   C


The output Should be

Code:

AAAAAAAAAB
XXXXXXXC


This space can be in any position starting from 5th column.
I tried this

Code:

  OPTION COPY
  INREC FIELDS=(5:5,80,SQZ=(SHIFT=LEFT))


But the SQZ Function is abending,Is there any other this can be done.
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: Wed Mar 05, 2008 11:07 pm    Post subject:
Reply with quote

The ABEND would be caused by an error message with ERET=ABEND in effect.

Please show the DFSORT messages you received.

It may be that you don't have the required DFSORT PTF for the SQZ function.

But it might also be the case that something else is your problem - for example, it might be that 5,80 is beyond the end of the record.

What is the RECFM and LRECL of your input file?
Back to top
View user's profile Send private message
ksathishkumar83

New User


Joined: 21 Nov 2006
Posts: 50
Location: India

PostPosted: Wed Mar 05, 2008 11:15 pm    Post subject:
Reply with quote

Hi Frank,

The record length is 100.
The below sort worked.
OPTION COPY
INREC FIELDS=(5:5,80)

when i include SQZ,It is abending.Can it be done any other way.
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: Wed Mar 05, 2008 11:21 pm    Post subject:
Reply with quote

Quote:
It is abending


As I said, there's an error message associated with the ABEND. What is it? Show me the DFSORT messages.
Back to top
View user's profile Send private message
ksathishkumar83

New User


Joined: 21 Nov 2006
Posts: 50
Location: India

PostPosted: Thu Mar 06, 2008 9:24 am    Post subject:
Reply with quote

The error message is
OUTREC STATEMENT : SYNTAX ERROR
SYNCSMF CALLED BY SYNCSORT; RC=0000
SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Thu Mar 06, 2008 9:48 am    Post subject:
Reply with quote

SQZ is DFSORT function and not available in SYNCSORT
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 9:22 pm    Post subject:
Reply with quote

ksathishkumar83,

Those are Syncsort messages. I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.

The DFSORT Forum is for DFSORT questions. I'm moving your post to the JCL Forum.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

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

Devzee wrote:
SQZ is DFSORT function and not available in SYNCSORT

The SQZ function IS supported in SyncSort for z/OS 1.3.

ksathishkumar83,

My guess is that the syntax error is occurring because you are running an earlier release of the product.
Back to top
View user's profile Send private message
ksathishkumar83

New User


Joined: 21 Nov 2006
Posts: 50
Location: India

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

in my shop DFSORT's ICETOOL is working..only SQZ is not working.Can it be done any other way.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

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

ksathishkumar83 wrote:
in my shop DFSORT's ICETOOL is working

Based on the messages you previously posted, you do not have DFSORT, so I assume that your ICETOOL applications are really SyncSort's SYNCTOOL.

ksathishkumar83 wrote:
...only SQZ is not working

This is because you do not have the current SyncSort release installed.

ksathishkumar83 wrote:
Can it be done any other way.

Let me think about it.
Back to top
View user's profile Send private message
Hari108
Currently Banned

New User


Joined: 29 Jun 2006
Posts: 5

PostPosted: Wed Mar 12, 2008 3:23 pm    Post subject:
Reply with quote

Quote:
ksathishkumar83 wrote:
Can it be done any other way.

Let me think about it.


Hi Alissa, Is there any solution to this?
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Wed Mar 12, 2008 8:46 pm    Post subject: Re: Removing Spaces with SORT
Reply with quote

ksathishkumar83 wrote:
This space can be in any position starting from 5th column.

Is the number of spaces always the same, no matter which position it starts in?
If so, how many spaces, and what is the last column the space(s) could start in?
Back to top
View user's profile Send private message
ksathishkumar83

New User


Joined: 21 Nov 2006
Posts: 50
Location: India

PostPosted: Wed Mar 12, 2008 9:34 pm    Post subject:
Reply with quote

the file length is 80 bytes.The lenth of the space may vary for each record.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Wed Mar 12, 2008 9:37 pm    Post subject:
Reply with quote

ksathishkumar83 wrote:
The lenth of the space may vary for each record.

Then I do not think SyncSort for z/OS 1.2 can do what you ask.
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 Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts SORT to append Month and YEAR in MMYY... tisamf DFSORT/ICETOOL 1 Wed Mar 08, 2017 4:46 pm
No new posts JCL sort Match and NoMatch rakeshsekar1987 SYNCSORT 2 Thu Feb 02, 2017 10:26 pm


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