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
 

 

ICETOOL CONVERSION

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
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    Post subject: ICETOOL CONVERSION
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: 8593
Location: Back in jolly old England

PostPosted: Mon Jul 22, 2013 5:23 pm    Post subject:
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    Post subject: Icetool conversion
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: 8593
Location: Back in jolly old England

PostPosted: Mon Jul 22, 2013 5:47 pm    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7241

PostPosted: Mon Jul 22, 2013 6:03 pm    Post subject: Reply to: ICETOOL CONVERSION
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: 2171
Location: @my desk

PostPosted: Tue Jul 23, 2013 9:47 am    Post subject:
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    Post subject: Reply to: ICETOOL CONVERSION
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    Post subject: Reply to: ICETOOL CONVERSION
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: 2171
Location: @my desk

PostPosted: Tue Jul 23, 2013 11:16 am    Post subject:
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: 1703
Location: Australia

PostPosted: Tue Jul 23, 2013 11:17 am    Post subject:
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    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7241

PostPosted: Tue Jul 23, 2013 11:54 am    Post subject: Reply to: ICETOOL CONVERSION
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: 2171
Location: @my desk

PostPosted: Tue Jul 23, 2013 2:29 pm    Post subject:
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    Post subject:
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: 2171
Location: @my desk

PostPosted: Tue Jul 23, 2013 6:35 pm    Post subject:
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

Site Director


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

PostPosted: Tue Jul 23, 2013 9:13 pm    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7241

PostPosted: Wed Jul 24, 2013 2:38 am    Post subject: Reply to: ICETOOL CONVERSION
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: 2171
Location: @my desk

PostPosted: Thu Jul 25, 2013 4:53 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts Conversion of a VB file to FB. isssal DFSORT/ICETOOL 1 Mon Oct 31, 2016 10:23 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm
No new posts EBCDIC to ASCII conversion using OCOPY mistah kurtz All Other Mainframe Topics 5 Tue Sep 06, 2016 2:26 pm


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