Debtors statement

bgbertrand

Member
Hi folks
I am faced by extremely long processing time in our statement runs. This is mainly due to the fact that f0311 has not been purged since inception, and that we have a great number of P035001 versions to run. This in turn negatively affect our month-end schedules. Has anyone tried solutions - beside purge - to reduce indexing and processing time?

Bruno
 
Bruno:

One possibility is, if all the DW versions use the same sort sequence (say,
at least the 1st few fields are the same), then you can create a logical
file over the F0311 which has the same key fields as the DW sequence. This
way, each version will not have to build an index each time. You may also
be able to use data select/omits in this new LF to reduce the number of
records that the DW has to sift thru. Then change the "Based on File" on
the "Additional Parameters" (or "Additional Information", I am at home
typing this) window on the DW versions, and you should see some much quicker
run times.

Regards,
Sally White




Sally White
SJSoftware, LLC
 
G'Day Bruno

Modifying the 'Addional Parameters' for a dreamwriter so that the 'File Output Type' is set to a value of '4 - Standard Logical file (Create & Keep)' will mean that a logical file with the same data selections and sequencing will be created and retained next time you run the version.

All subsequent running of this version will use this logical file and processing time will be improved.

Disk utilisation may be a consideration if you choose to use this option.

Regards

Gavin

IT Consultant
World/Oneworld Applications support
World Development
[email protected]
 
Back
Top