OVERLAY, SQUEEZE, JFY, ICETOOL, SORT



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

OVERLAY, SQUEEZE, JFY, ICETOOL, SORT

Postby denis.dhimitri » Sat Feb 09, 2008 9:28 pm

Hello to everyone,

I'm having problems with the sort release prior to April 2006 which doesen't accept instructions like JFY, SQZ, OVERLAY....
I've an input file like this:

File A:
XXXXXXXXXXXXXXXXXXXX$000000000000000001$XXXXXXXXXXXXXXXXXX$000000000000000000$XXXXXXXXXXXXXXXXXX$
$000000000000000000$ $000000000000123456$ $
XXXXXXXXXXXXXXXXXXXX$000000001234567890$XXXXXXXXXXXXXXXXXX$000000000000000000$XXXXXXXXXXXXXXXXXX$

The result I'd liketo have is the following:
File B:
XXXXXXXXXXXXXXXXXXXX$000000000000000001$XXXXXXXXXXXXXXXXXX$$$XXXXXXXXXXXXXXXXXX$
$$$$$$000000000000123456$$$
XXXXXXXXXXXXXXXXXXXX$000000001234567890$XXXXXXXXXXXXXXXXXX$$$

So, when I've blanks or zeroes I should substitute them with $ and when I've values higher than blanks or zeroes should keep the same format of layout. Does anyone have any idea of how to do this via SORT or ICETOOL or ICEMAN ? Thank's in advance

Denis
denis.dhimitri
 
Posts: 11
Joined: Sat Feb 09, 2008 9:11 pm
Has thanked: 0 time
Been thanked: 0 time

Re: OVERLAY, SQUEEZE, JFY, ICETOOL, SORT

Postby CICS Guy » Sat Feb 09, 2008 10:25 pm

denis.dhimitri wrote:I'm having problems with the sort release prior to April 2006 which doesen't accept instructions like JFY, SQZ, OVERLAY....
I know it's a stupid question, but why don't you have the PTF installed? It's free and easy.....
CICS Guy
 
Posts: 246
Joined: Wed Jun 20, 2007 4:08 am
Has thanked: 0 time
Been thanked: 0 time

Re: OVERLAY, SQUEEZE, JFY, ICETOOL, SORT

Postby Frank Yaeger » Sun Feb 10, 2008 5:53 am

You will need the April, 2006 PTF to do this kind of thing. Ask your System Programmer to install it. The alternative would be to write an E15 of your own with the logic to do what you want.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: OVERLAY, SQUEEZE, JFY, ICETOOL, SORT

Postby denis.dhimitri » Sun Feb 10, 2008 7:50 pm

O.K Mr.Yaeger, thank's a lot for your help.

Denis
denis.dhimitri
 
Posts: 11
Joined: Sat Feb 09, 2008 9:11 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post