I definitely think you should go for loading from a flat file using the LOAD Utility and Greg's point about having the file in Clustering Index Order is important. When sorting your flat file, remember that some columns may be nullable. Such columns should be sorted by 1) the Null Indicator...
I tried IDXFIX but couldn't get the blessed thing to overcome the problem for me. I concluded that either my machine was still too fast or I wasn't using it properly, so gave up. What parameter value do you use Jane?
This problem has been discussed before in this forum. In a nutshell, your machine is too fast (!). DB/4 uses a naming algorithm based on the current time for the temporary files it needs in such operations. With a fast machine, it creates files so quickly that the file names come out the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.