in icetool using i need to keep last 3 records



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

in icetool using i need to keep last 3 records

Postby muthu455 » Mon Apr 23, 2012 5:53 pm

my in put file having 1000 records... i need to keep only last 3 records only so i used the icetool utilities
//xxxxxxAB JOB NOTIFY=&SYSUID
//STEP1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DSN=xxxxxx.MUTHU.PS,DISP=SHR
//OUT DD DSN=xxxxx.MUTHU.PS1,DISP=OLD
//TOOLIN DD *
SUBSET FORM(IN1) TO(OUT) INPUT KEEP LAST(3)
/*
above this program i'm getting the error like this how can i solve this error
ICE632I 0 SOURCE FOR ICETOOL STATEMENTS: TOOLIN


ICE630I 0 MODE IN EFFECT: STOP

SUBSET FORM(IN1) TO(OUT) INPUT KEEP LAST(2)
$
ICE614A 0 INVALID OPERATOR
ICE602I 0 OPERATION RETURN CODE: 12


ICE601I 0 DFSORT ICETOOL UTILITY RUN ENDED - RETURN CODE: 12
muthu455
 
Posts: 21
Joined: Sat Apr 14, 2012 3:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: in icetool using i need to keep last 3 records

Postby MrSpock » Mon Apr 23, 2012 6:46 pm

I'm not an expert here, but I imagine that should be "FROM", not "FORM".
User avatar
MrSpock
Global moderator
 
Posts: 807
Joined: Wed Jun 06, 2007 9:37 pm
Location: Raleigh NC USA
Has thanked: 0 time
Been thanked: 4 times

Re: in icetool using i need to keep last 3 records

Postby BillyBoyo » Mon Apr 23, 2012 8:57 pm

Well, that's right MrSpock.

Only thing is, it doesn't get that far (likely) is it is an old version of ICETOOL which does not have SUBSET, which is where the "coded" $ is pointing.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: in icetool using i need to keep last 3 records

Postby NicC » Mon Apr 23, 2012 11:07 pm

Why do you not check in the manual for your level of ICETOOL/DFSORT to see if the keywords you are using are there. This has been suggested before and you have been told NOT post here if your version does not support what you are trying to use. Just posting willy-nilly without even researching is just downright bad manners.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: in icetool using i need to keep last 3 records

Postby Frank Yaeger » Mon Apr 23, 2012 11:23 pm

muthu455,

The version of DFSORT and z/OS you are using are no longer supported, and your site has NOT even kept up with the DFSORT PTFs available, so you can't use most of the newer DFSORT functions.

Ask your System Programmers why they are still on an unsupported z/OS release.

Please stop posting "why doesn't it work" questions.
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


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post