Page 1 of 1

in icetool using i need to keep last 3 records

PostPosted: Mon Apr 23, 2012 5:53 pm
by muthu455
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

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

PostPosted: Mon Apr 23, 2012 6:46 pm
by MrSpock
I'm not an expert here, but I imagine that should be "FROM", not "FORM".

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

PostPosted: Mon Apr 23, 2012 8:57 pm
by BillyBoyo
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.

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

PostPosted: Mon Apr 23, 2012 11:07 pm
by NicC
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.

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

PostPosted: Mon Apr 23, 2012 11:23 pm
by Frank Yaeger
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.