Posted: Sat Mar 06, 2004 9:16 pm Post subject: Error in ICETOOL control statement "ADD" verb....
Hello,
Whatz the error here !! I am pasting the DFSMSG .
Code:
1ICE200I 0 IDENTIFIER FROM CALLING PROGRAM IS 0001
ICE143I 0 BLOCKSET COPY TECHNIQUE SELECTED
ICE000I 0 - CONTROL STATEMENTS FOR 5740-SM1, DFSORT REL 14.0 - 21:07 ON SAT MAR 06, 2004 -
0 OUTREC FIELDS=(1,5,6,4,6,4,14,4,18,4,
22:06,04,PD,ADD,06,04,PD,80:X)
$
ICE007A E SYNTAX ERROR
ICE146I 0 END OF STATEMENTS FROM CTL1CNTL - PARAMETER LIST STATEMENTS FOLLOW
DEBUG NOABEND,ESTAE
OPTION LIST,MSGPRT=ALL,MSGDDN=DFSMSG,RESINV=0,SORTDD=CTL1,SORTIN=FILEIN*
,SORTOUT=OUT,COPY
ICE052I 3 END OF DFSORT
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Sun Mar 07, 2004 11:01 am Post subject:
hsubra,
In order to use DFSORT arithmetic expressions (e.g. ADD), you need to have DFSORT R14 PTF UQ90053 (Feb, 2003) installed. The syntax error indicates you do NOT have this PTF installed. Ask your System Programmer to install PTF UQ90053 (it's free). For complete information on the new features available with PTF UQ90053, see:
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Sun Mar 07, 2004 7:30 pm Post subject:
Hsubra,
As frank and cogito mentioned you need to have the PTF UQ90053 installed for performing arthimetic operations. For some reason if you are not able to get the ptf applied , here is an alternative solution.
A brief explanation of the job, The first copy operator splits the a single input record into 2 records with a seqnum attached to it.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Sun Mar 07, 2004 7:36 pm Post subject:
Note that Kolusu's "trick" can be used for ADD and (with some more tricks) SUB, but it can't be used for the other DFSORT arithmetic operations - MIN, MAX, MUL, DIV, MOD. So it's best to get PTF UQ90053 installed. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum