Search results

I have a situation where the only apparent solution is based on querying the _lock table. Yet _lock is only indexed on _lock._lock-id, so I end up doing a full table scan. The situation is that when a record is being updated, a user can invoke a 'field help' function to obtain details on the...

ENCODE is a proprietary algorithm. If I told you then I'd have to .... no - wait that's the wrong response. Seriously though, I asked about this myself some time ago. ENCODE is not based on a public algorithm like MD5 or SHA-1. I submitted a request for a replacement (or additional) function...

I would like be able to pass information from an executing procedure to any DB triggers activated by that procedure. The main problem, as I see it, is that multiple procedures may be active in a given user session - any of which may fire a given DB trigger. When a trigger fires, I want to...

The objective is to be able to archive data from the DB to an OS file, 'hash' it to generate a 'message digest, then store the message digest and the file name in the DB. Before reloading the archive file, the message digest would be re-computed and compared to the original. If they match...

I understand the use of encode for password management. What I an interested in is how well 'encode' compares to general one-way hash algoriths such as SHA-1, especially on large files. The application would be to generate an output file (archived DB records), compute a 'hash' on the file...

Our application generates 'dynamic queries' based on Client input parameters which are passed to a 'state-aware' Web Agent. An initial set on 'n' records are passed back to the Client in a Reply. When the Client requests additional data, a 2nd request is passed to the Web Agent (the same Web...