Calculating top vaues

pravin1581 · Post by **pravin1581** » Wed Mar 14, 2007 7:48 am

DSguru2B wrote:On hashed file. How you are doing for median in the routine.

Can we execute a sql on hash file ?

DSguru2B · Post by **DSguru2B** » Wed Mar 14, 2007 8:00 am

The routine I posted hereruns getCMD on UV which is sql on a hashed file. I even gave a full description. If thats hard to follow,then as Craig advised, load your file in a work table and do the sql and get done with it.

chulett · Post by **chulett** » Wed Mar 14, 2007 8:10 am

A UV stage over the hashed file will allow SQL to be run against the hashed data. A couple of caveats - the hashed file will need to be in an 'account' or have a VOC record built for it. And it will more than likely be slow without specific indexes built to support the queries. Search for forum for BUILD.INDEX for many discussions on the topic.

Simpler to load a work table.

kumar_s · Post by **kumar_s** » Wed Mar 14, 2007 4:56 pm

Or use ODBC over your file if you have the license for it.