View previous topic :: View next topic
|
Author |
Message |
sel_ramji2009
New User
Joined: 18 Jul 2013 Posts: 18 Location: india
|
|
|
|
HI
i am trying to convert some icetool steps to normal sort steps that is supported by DMEXPRESS on unix platforms .
Here is the ICETOOL card :
COUNT FROM(INCNT) RC4 HIGHER(6500)
I need to convert this to normal SORT card .i can understand that it is cnting the records ,and if it reaches above 6500 it throws RC as 4 ,how can this be done thru a normal sort card ???somebody pls help
i have some more cards to be converted
SELECT FROM(IN) TO(OUT) ON(1,4,CH) ON (6,7,CH) EQUAL(2) - what does equal mean here in icetool ? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
So are you saying that you want to run what is currently a mainframe job on a unix platform. |
|
Back to top |
|
|
sel_ramji2009
New User
Joined: 18 Jul 2013 Posts: 18 Location: india
|
|
|
|
yes , we are doing some migration .Mainframes applications are moved to unix platforms . but the code ,jobs are mostly same with some extra features that are supported on unix .Unix is not supporting ICETOOL ,it is supporting only DMEXPRESS commands .so we have to convert all ICETOOL cards to normal cards .can you pls help ? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
And will this unix box be able to deal with the ICETOOL equivilent of setting a z/OS return code as shown in your example.
Does unix support return code processing or an equivilent.
Maybe something to find out before you get too far down the road.
Also, we do not have access to the DMEXPRESS documentation.
What have you researched Yourself so far ?
Would also question the wisdom of posting a NON mainframe topic on a mainframe forum. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Why don't you ask the software vendor? |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
SELECT FROM(IN) TO(OUT) ON(1,4,CH) ON (6,7,CH) EQUAL(2) - what does equal mean here in icetool ? |
This will copy all the records from input to output where exactly 2 duplicate records exist for the key - 4 bytes at pos-1 + 7 bytes at pos-6.
It might help if you respond to the questions expat has asked, on the feasibility of this 'conversion'. |
|
Back to top |
|
|
sel_ramji2009
New User
Joined: 18 Jul 2013 Posts: 18 Location: india
|
|
|
|
Hey expat ,
see there are 2 things ,
1)unix does not support ICETOOL at all
2)unix supports DMEXPRESS sort commands which are more similar to DFSORT commands
3)unix can also handle return codes .I told you in my initial post that we are rehosting the mainframes applications to unix box.functionality of the applications remains the same with some changes that is supported on unix. so hope this is clear to you |
|
Back to top |
|
|
sel_ramji2009
New User
Joined: 18 Jul 2013 Posts: 18 Location: india
|
|
|
|
Arun Raj,
Thanks much for clearing that doubt .so the icetool command can be converted as SORT FIELDS=(1,4,CH,A,6,7,CH,A) OPTION STOPAFT=2,will this sort card work ? is it equivalent to icetool stmt SELECT FROM(IN) TO(OUT) ON(1,4,CH) ON (6,7,CH) EQUAL(2) ? |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
unix supports DMEXPRESS sort commands which are more similar to DFSORT commands |
I think you meant Syncsort. DFSORT and Syncsort are competitive products.
Quote: |
unix can also handle return codes .I told you in my initial post that we are rehosting the mainframes applications to unix box.functionality of the applications remains the same with some changes that is supported on unix. so hope this is clear to you |
Not exactly clear at least to me how the RC issued by sort will be processed in a Unix environment.
Quote: |
so the icetool command can be converted as SORT FIELDS=(1,4,CH,A,6,7,CH,A) OPTION STOPAFT=2,will this sort card work ? is it equivalent to icetool stmt SELECT FROM(IN) TO(OUT) ON(1,4,CH) ON (6,7,CH) EQUAL(2) ? |
No, It will not work equivalent to the SELECT which you have shown. But there could be alternatives for sure. |
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
Quote: |
Thanks much for clearing that doubt .so the icetool command ........ |
I think you should read Arun's reply again, I doubt you understood his reply.
Gerry |
|
Back to top |
|
|
sel_ramji2009
New User
Joined: 18 Jul 2013 Posts: 18 Location: india
|
|
|
|
Arun ,
Never mind about unix environment .we are rehosting something on unix for which we have done all the required setups .If i start explaining all those then there will be a deviation .but still jobs can handle return codes from each step right irrespective of unix/mainframes environment .i am just asking the icetool equivalent in SORT or SYNCSORT for these 2 queries below ,
1) SELECT FROM(IN) TO(OUT) ON(1,4,CH) ON (6,7,CH) EQUAL(2)
2) COUNT FROM(INCNT) RC4 HIGHER(6500) |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
You have a product which runs on Unix. It supports at least a subset of Mainframe sort products.
You have yourself accurately described what one of the "tool" examples is doing, and Arun has described the other.
We have no manual for your product. It's not likely that anyone here has access to the product. You licensed the software, and the license includes support. You have been "sold" the product on the basis of it being able to support, generally, Sort Control Cards.
Talk to the Vendor. If the Vendor is not going to touch "tool", then work through the manuals youself (small number of tool step) or get a consultant.
Perhaps you could find a Unix forum where someone has knowledge of the product? Perhaps the Vendor can suggest somewhere?
Are we, here, going to assist, for free, in you getting off the Mainframe? Not what we volunteer for. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Hi Bill,
AFAIK 'DMExpress' is a Syncsort product. Chances are there that the Syncsort control cards can work the same way in DMExpress as well.
sel_ramji2009,
Have you already tried running simple sort applications with DMXpress in your Unix environment.? Were the results same as that you got with Syncsort? Also which version of Syncsort do you have? |
|
Back to top |
|
|
sel_ramji2009
New User
Joined: 18 Jul 2013 Posts: 18 Location: india
|
|
|
|
Arun ,
yes we converted some icetool cards to normal sort cards and it did run in unix .got results same as in icetool cards |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Arun Raj wrote: |
Also which version of Syncsort do you have? |
We are trying to help you.
But by NOT telling us the information that only you know, but none else here, you are not helping yourself. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Yes, DMX is a Syncsort product. Before DMX, i used Syncsort on Unix and it was an excellent product.
I realize this is kind of late in your migration, but is everyone aware of the change in collating sequence between the mainframe and unix? Mainframe (ebcdic) sorts letters before numbers while in unix (ascii) numbers sort before letters. Technically, this is not a big deal, but often users have issues with this.
Suggest you try the ICETOOL control statements in a DMX execution and see what happens. If anything mysterious happens, call Syncsort Support. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Then this one really won't work.
My point was, since we don't know what level of function the unix SyncSort has, and since the migration was a pre-planned exercise, and since SyncSort have licensed and provide support for what it has been agreed it can do, I don't see a need for a forum to be involved :-)
Admittedly this could be described as "Situation Normal"... |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
i am just asking the icetool equivalent in SORT or SYNCSORT for these 2 queries below ,
1) SELECT FROM(IN) TO(OUT) ON(1,4,CH) ON (6,7,CH) EQUAL(2)
2) COUNT FROM(INCNT) RC4 HIGHER(6500) |
The first one very well could be converted to a 'sort' application. But for the second one if you need the exact equivalent, you might need the latest Syncsort version which is able to issue pre-defined RCs when output file is non-empty (of course if you are particular about not swapping the RC=0 and RC=4 conditions). |
|
Back to top |
|
|
|