Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
Posted: Thu Apr 01, 2004 6:30 am Post subject:
Thanks kolusu,
Do we have any other way to overcome this issue. The no. of records in my File 2 is over a million. Again as I have said earlier all we have here is 1999 version of Syncsort.
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Thu Apr 01, 2004 11:17 am Post subject:
Quote:
Yes the solution is dependent on the no: of records in file2. Since we are generating dynamic change control cards , we cannot have more than 500 records. Again this no: is dependent on the size of the field also.
For the record, note that the solution using the DFSORT/ICETOOL SPLICE operator has no such limitations.
If anybody on this list would like some documents prepared by the DFSORT Team on what we see as the advantages of DFSORT, as well as migration considerations, send me an e-mail offline (yaeger@us.ibm.com). Please put "DFSORT" somewhere in your Subject line to catch my attention. _________________ 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
Joined: 14 Nov 2003 Posts: 66 Topics: 0 Location: St Cloud, Minnesota USA
Posted: Sun Apr 04, 2004 6:49 pm Post subject:
In about an hour you could write a very fast Cobol program using a direct index table to do what you want. It would not have the any restrictions on the size of the data file. There would be a restriction on the file containing the country codes. For instance if the country code is 3 digits numeric, then you could not have more than 1000 entries. If 5 digits then the limit would be 100,000 entries.
there are other advantages in using a program. I always create a control report so that our data integrity group can run to run control report balancing. I would be willing to wager that the Cobol program would be faster and use less resources.
This is a very trivial program to write. _________________ Chuck Haatvedt
email --> clastnameatcharterdotnet
(replace lastname, at, dot with appropriate
characters)
All times are GMT - 5 Hours Goto page Previous1, 2
Page 2 of 2
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
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
