DSXchange

I've done the same as suggested, it now is working fine, great!

Thanks man.

Thanks Ray and Craig. The hashed file has 10 rows only. The simple test job has two stages only, one transformer creates 10,000 records and keeps calling the routine and writes the output to a sequential file. As Craig said, currently each call to the routine needs to open the hashed file, over and ...

Hi All, I created a routine which reads from a hash file with the hash key, but seems that the performance is bad. The codes I am using is as following: vCommand = "SELECT Hash_File_Name WITH @ID = Hash_Key" Print " Start Time : " : Time() Execute vCommand capturing output Print " End Time : " : Tim...