IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ICETOOL CONVERSION


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
sel_ramji2009

New User


Joined: 18 Jul 2013
Posts: 18
Location: india

PostPosted: Mon Jul 22, 2013 5:13 pm
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Mon Jul 22, 2013 5:23 pm
Reply with quote

So are you saying that you want to run what is currently a mainframe job on a unix platform.
Back to top
View user's profile Send private message
sel_ramji2009

New User


Joined: 18 Jul 2013
Posts: 18
Location: india

PostPosted: Mon Jul 22, 2013 5:27 pm
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Mon Jul 22, 2013 5:47 pm
Reply with quote

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
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Mon Jul 22, 2013 6:03 pm
Reply with quote

Why don't you ask the software vendor?
Back to top
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Tue Jul 23, 2013 9:47 am
Reply with quote

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
View user's profile Send private message
sel_ramji2009

New User


Joined: 18 Jul 2013
Posts: 18
Location: india

PostPosted: Tue Jul 23, 2013 11:01 am
Reply with quote

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
View user's profile Send private message
sel_ramji2009

New User


Joined: 18 Jul 2013
Posts: 18
Location: india

PostPosted: Tue Jul 23, 2013 11:05 am
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Tue Jul 23, 2013 11:16 am
Reply with quote

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
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Tue Jul 23, 2013 11:17 am
Reply with quote

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
View user's profile Send private message
sel_ramji2009

New User


Joined: 18 Jul 2013
Posts: 18
Location: india

PostPosted: Tue Jul 23, 2013 11:39 am
Reply with quote

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
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Jul 23, 2013 11:54 am
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Tue Jul 23, 2013 2:29 pm
Reply with quote

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
View user's profile Send private message
sel_ramji2009

New User


Joined: 18 Jul 2013
Posts: 18
Location: india

PostPosted: Tue Jul 23, 2013 4:53 pm
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Tue Jul 23, 2013 6:35 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Jul 23, 2013 9:13 pm
Reply with quote

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
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Wed Jul 24, 2013 2:38 am
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


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

PostPosted: Thu Jul 25, 2013 4:53 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts 10 byte RBA conversion DB2 2
No new posts 10 byte RBA conversion -non applicati... JCL & VSAM 1
No new posts Shift left VB record without x00 endi... DFSORT/ICETOOL 11
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
No new posts how to calculate SUM for VB file usin... JCL & VSAM 1
Search our Forums:

Back to Top