Frank Yaeger Sort Forum Moderator
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
Posted: Wed Mar 31, 2004 10:26 am Post subject: |
|
|
Paneendra,
If by "not working", you mean you get a "syntax" error for FIRSTDUP, that means you don't have DFSORT R14 PTF UQ99331 (March, 2002) installed. You need that PTF to use FIRSTDUP. Ask your System Programmer to install DFSORT R14 PTF UQ90053 (Feb, 2003) - that will get your shop up-to-date on DFSORT function PTFs (the PTFs are free).
In the meantime, you can get the equivalent of FIRSTDUP by using a SELECT operator with TO(T1) ALLDUPS followed by another SELECT operator with FROM(T1) FIRST.
If by "not working", you mean something else, explain what you mean. _________________ 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 |
|