Can we execute a sql on hash file ?DSguru2B wrote:On hashed file. How you are doing for median in the routine.
Calculating top vaues
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.![Wink :wink:](./images/smilies/icon_wink.gif)
Simpler to load a work table.
![Wink :wink:](./images/smilies/icon_wink.gif)
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers