| View previous topic :: View next topic |
| Author |
Message |
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
 Posted: Thu Jun 07, 2007 3:14 pm Post subject: |
 |
|
nimb,
I did not go through the entire discussion. I'm just writing based on your last post:
Syncsort v 1.1 does not have the capability to replace a hardcoded text to a variable. You can use a variable text only in NOMATCH condition and not within CHANGE.
I mean to say that you cannot use 41,18 (variable text) within CHANGE. You can replace C' ' by another hardcoded value of 18 bytes long.
Hope this helps,
Thanks,
Phantom |
|
| Back to top |
|
 |
nimb
Beginner
Joined: 01 Feb 2007
Posts: 8
Topics: 1
|
| Posted: Thu Jun 07, 2007 3:22 pm Post subject: |
|
|
| I thought so too after it gave the error, but I will wait for Kolusu to get another magic to work before giving up. |
|
| Back to top |
|
|
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
| Posted: Thu Jun 07, 2007 3:23 pm Post subject: |
|
|
Kolusu,
Are you sure | Code: | | CHANGE=(18,C' ',41,18), |
works with Syncsort 1.1 DR ?
Thanks,
Phantom |
|
| Back to top |
|
|
CICS Guy
Intermediate
Joined: 30 Apr 2007
Posts: 292
Topics: 3
|
| Posted: Thu Jun 07, 2007 3:40 pm Post subject: Re: Writing 1 Output based on 2 conditions in Input file. |
|
|
ninb, I ask again, | Quote: | I need only one Output file.
Can we do this using Sort/Icetool in one step. |
What's wrong with two steps? |
|
| Back to top |
|
|
nimb
Beginner
Joined: 01 Feb 2007
Posts: 8
Topics: 1
|
| Posted: Thu Jun 07, 2007 3:45 pm Post subject: |
|
|
| It is a change required in the existing system and if I have to add the step it would be lots of changes in jobs that do not even need this change. So I am trying to achieve it by a change in one control card rather that 100 jobs. |
|
| Back to top |
|
|
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
| Posted: Thu Jun 07, 2007 3:52 pm Post subject: |
|
|
nimb,
I believe there is a mis-communication between you and CICS_Guy. I believe you are referring to 1 Job step and CICS_Guy is referring to 1 Job step - but 2 Pass (using Synctool).
I'm gonna ask you again - would you be interested in a "1 Step - 2 Pass Solution" ???
Thanks,
Phantom |
|
| Back to top |
|
|
CICS Guy
Intermediate
Joined: 30 Apr 2007
Posts: 292
Topics: 3
|
| Posted: Thu Jun 07, 2007 4:08 pm Post subject: |
|
|
| nimb wrote: | | It is a change required in the existing system and if I have to add the step it would be lots of changes in jobs that do not even need this change. So I am trying to achieve it by a change in one control card rather that 100 jobs. |
Sounds like..... 
The easiest solution would be to upgrade to a somewhat current level of your sort utility..... | Quote: | | lots of changes in jobs that do not even need this change |
Then don't change them, for crips sake, what kind of environment are you working under? |
|
| Back to top |
|
|
nimb
Beginner
Joined: 01 Feb 2007
Posts: 8
Topics: 1
|
| Posted: Thu Jun 07, 2007 4:15 pm Post subject: |
|
|
Phantom, I can try the 1 Step - 2 Pass Solution. Cna you give me details?
I am still hoping Kolusu will come up with something |
|
| Back to top |
|
|
William Thompson
Beginner
Joined: 15 May 2007
Posts: 5
Topics: 0
|
| Posted: Thu Jun 07, 2007 5:09 pm Post subject: |
|
|
| nimb wrote: | | I am still hoping Kolusu will come up with something |
Well, without reading a manual, I guess you could throw a virgin or two into the volcano......  |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12401
Topics: 75
Location: San Jose
|
| Posted: Fri Jun 08, 2007 3:31 am Post subject: |
|
|
| Phantom wrote: | Kolusu,
Are you sure | Code: | | CHANGE=(18,C' ',41,18), |
works with Syncsort 1.1 DR ?
Thanks,
Phantom |
Phantom,
I am NOT sure and I don't have a way of testing and it has been a long day for me and I did not have time/patience to read syncsort 1.1 manual
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12401
Topics: 75
Location: San Jose
|
| Posted: Fri Jun 08, 2007 3:33 am Post subject: |
|
|
| Quote: |
I am still hoping Kolusu will come up with something
|
nimb,
I am out of ideas. may be product supporters like alissa might be able to help you.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
amargulies
Beginner
Joined: 10 Jan 2007
Posts: 123
Topics: 0
|
| Posted: Fri Jun 08, 2007 9:16 am Post subject: |
|
|
Allowing the replacement field in the CHANGE subparameter to be another field from within the input record if the input field equals a search constant was introduced in SyncSort for z/OS 1.2.1.
_________________
Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com |
|
| Back to top |
|
|
Phantom
Data Mgmt Moderator
Joined: 07 Jan 2003
Posts: 1056
Topics: 91
Location: The Blue Planet
|
| Posted: Fri Jun 08, 2007 9:20 am Post subject: |
|
|
| kolusu wrote: | | Phantom wrote: | Kolusu,
Are you sure | Code: | | CHANGE=(18,C' ',41,18), |
works with Syncsort 1.1 DR ?
Thanks,
Phantom |
Phantom,
I am NOT sure and I don't have a way of testing and it has been a long day for me and I did not have time/patience to read syncsort 1.1 manual
Kolusu |
Well...No issues...I checked it for you... This feature is available only syncsort v 1.2.1 and above. Please see below
Taken from "Syncsort v 1.2.1 - Summary of Changes" document
| Quote: |
The CHANGE subparameter now allows the replacement field to be another
field from within the input record if the input field equals a search constant.
|
Thanks,
Phantom |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
