Creating secondary index on hash file from a routine
Posted: Tue Oct 11, 2005 8:42 pm
Hi all
I have a hash file being access using UV stage by partial key, for a multi-row lookup, that was performing very badly. I created an index on the lookup column, from the UV command line, reran the job and the performance was closer to what I expected. Now I want to create and build the index in a before stage routine, but I'm not getting any joy.
I have tried to utiles the code in the ExecTCL routine but to no avail.
Here is the code I'm using -
Where vHashFile is the incoming hash file, and VinddexCol is the column to create the index on.
Any help appreciated...
I have a hash file being access using UV stage by partial key, for a multi-row lookup, that was performing very badly. I created an index on the lookup column, from the UV command line, reran the job and the performance was closer to what I expected. Now I want to create and build the index in a before stage routine, but I'm not getting any joy.
I have tried to utiles the code in the ExecTCL routine but to no avail.
Here is the code I'm using -
Code: Select all
Call DSExecute("TCL", "CREATE.INDEX vHashFile vIndexCol", Output, SystemReturnCode)
Any help appreciated...