View previous topic :: View next topic
|
Author |
Message |
mihirjana
New User
Joined: 25 Jul 2005 Posts: 2
|
|
|
|
My problem definition is:
I have two files.
Customer file: It has two fields. Customer name and customer no
Customer name has no spaces in between
Customer name is x(25) and cusomer no is s9(6).
Check file: It has 2 fields.
Check no 9(10).
Check alpha x(10). It has no spaces in between.
Let's say,
File A has below records
zabc?efg 12345
@kjlabcmnp 1234
File B
999 abc
888 efg
I want to find if my check alpha entire string is present anywhere in the customer name field
If that is present then I want my output to be like..
999 abc zabc?efg 12345
999 abc @kjlabcmnp 1234
888 efg zabc?efg 12345
I tried doing this through sequential processing and doing the search of substring.
But File A and File B both contains approximately 5 millions of records.
So my job takes around 24 hous which is not feasibe at all.
Let me know how I can do this with reasonable performance.
Thanks,
Mihir |
|
Back to top |
|
|
shobam
New User
Joined: 18 Jul 2005 Posts: 34 Location: CN
|
|
|
|
Quote: |
sequential processing and doing the search of substring. |
You can use INSPECT to make a search for the substring.
How did you made your search? Could you please let us know. |
|
Back to top |
|
|
mihirjana
New User
Joined: 25 Jul 2005 Posts: 2
|
|
|
|
Hi,
The problem is not with the search.
I have tried using different logic involving, inspect, string etc.
My programms works fine.
But the approach with the cobol inspect etc is not feasible as 5 millins records are present in both files which leads to 24 hours of job execution.
Thanks,
Mihir |
|
Back to top |
|
|
die7nadal
Active User
Joined: 23 Mar 2005 Posts: 156
|
|
|
|
Mihir,
Honestly ur logic is still unclear,bcos of the 3 records in ur output file with 2 records in each of the Input file. INSPECT can be very expensive for complex string operations. So can you show me the code that u tried with out the INSPECT Function. |
|
Back to top |
|
|
|