|
View previous topic :: View next topic
|
| Author |
Message |
ksathishkumar83
New User
Joined: 21 Nov 2006
Posts: 50
Location: India
|
|
|
|
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 |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
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 |
|
|
ksathishkumar83
New User
Joined: 21 Nov 2006
Posts: 50
Location: India
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
As I said, there's an error message associated with the ABEND. What is it? Show me the DFSORT messages. |
|
| Back to top |
|
|
ksathishkumar83
New User
Joined: 21 Nov 2006
Posts: 50
Location: India
|
|
|
|
The error message is
OUTREC STATEMENT : SYNTAX ERROR
SYNCSMF CALLED BY SYNCSORT; RC=0000
SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE |
|
| Back to top |
|
|
Devzee
Active Member
Joined: 20 Jan 2007
Posts: 684
Location: Hollywood
|
|
|
|
| SQZ is DFSORT function and not available in SYNCSORT |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
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 |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
| 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 |
|
|
ksathishkumar83
New User
Joined: 21 Nov 2006
Posts: 50
Location: India
|
|
|
|
| in my shop DFSORT's ICETOOL is working..only SQZ is not working.Can it be done any other way. |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
| 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 |
|
|
Hari108
Currently Banned
New User
.jpg)
Joined: 29 Jun 2006
Posts: 5
|
|
|
|
| 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 |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
| 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 |
|
|
ksathishkumar83
New User
Joined: 21 Nov 2006
Posts: 50
Location: India
|
|
|
|
| the file length is 80 bytes.The lenth of the space may vary for each record. |
|
| Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007
Posts: 496
Location: USA
|
|
|
|
| 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 |
|
|
|
|
