The tricks on the "SMART DFSORT TRICKS" document were really helpful. Thanks for putting all of them together.
I have a question regarding the Merging done using the splicing technique.
I have a requirement to merge two really big files. The merge condition is based on 2 key fields.
The two input files have roughly 5 fields and record length of 300 to 400.
For merging we have three options in our shop.
1) Using DB2 tables and then merging together using queries. And then write them to an external file.
2) Reading them into SAS databases and then merging using DATA step and then writing to external file.
3) Using DFsort merging technique.
Could you please tell me which technique is better so that the CPU usage is less.
Also could you please tell me which technique is optimum for ultilising less temp work space.
Also if it is not confidential.... "who wrote "SMART DFSORT TRICKS e-book???"