Posted: Wed Mar 14, 2007 7:48 am
Can we execute a sql on hash file ?DSguru2B wrote:On hashed file. How you are doing for median in the routine.
Page 3 of 3
Posted: 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.
Posted: 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.
Simpler to load a work table.
Posted: Wed Mar 14, 2007 4:56 pm
Or use ODBC over your file if you have the license for it.