View previous topic :: View next topic |
Author |
Message |
rajain9 Beginner
Joined: 07 Mar 2006 Posts: 1 Topics: 1
|
Posted: Tue Mar 07, 2006 2:36 am Post subject: Eztrieve Help required !!! |
|
|
a) Sort record in the from file (File A), find the duplicate records and write them into another File B.
b). From this File B, create a Report that should contain the following information:
STATE
POLICY
DIST
AGENT
EFF-DATE
BUSINESS-CODE
KOR
COMMISSION-CODE
ACCOUNT-NUMBER
77-AC-AMT
53-AC-AMT
81-AC-AMT
06-AC-AMT
01-04-AC-AMT
DUP-CNT |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Phantom Data Mgmt Moderator
![Data Mgmt Moderator Data Mgmt Moderator](images/ranks/Phantom.jpg)
Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Tue Mar 07, 2006 5:57 am Post subject: |
|
|
rajain9,
You have not provided sufficient information for us to provide a solution. Please post the DCB parameters (RECFM and LRECL) of your input files - A & B. The Column to be Sorted onto (the Key field). and the layout of your report (sample report).
We would be able to help you out only when you provide us sample input and sample output with all the requested information.
Thanks,
Phantom |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|
|