HP3000-L Archives

January 2007, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
"F. Alfredo Rego" <[log in to unmask]>
Reply To:
F. Alfredo Rego
Date:
Thu, 4 Jan 2007 19:51:24 -0700
Content-Type:
text/plain
Parts/Attachments:
text/plain (58 lines)
At 11:50 AM -0600 1/2/07, Denys Beauchemin wrote:

...
>So, big deal you say.  How do I fix this?  Well, changing the data type is
>the solution. 

Beware of anything that includes the phrase "the solution" ;-)

I am sure Denys meant "a solution".


>IMAGE does not care what you put in the various fields.  So,
>if you wanted to use hashing, where IMAGE uses all 64 bits for address
>calculation, you could simply redefine the data item as an X8 and let
>whatever tool you use to do the trick recalculate all the record based on
>hashing instead of just modulo.  Your programs would not know the difference
>as long as they are not interrogating IMAGE with DBINFO to find out what
>type of data is ostensibly in the field.  In other words, let's say you are
>using BASIC; if you do a DBGET of the item using a REAL buffer to receive
>the data, it will go right in there and be usable by the program as is.
>
>This will defeat Query and other similar programs to which you cannot apply
>a dictionary of some type.  These programs will interrogate IMAGE and get
>told the data is X and they will expect that and be surprised.
>
>On further thought, I would probably change it from R4 to P16.  That will
>still hash.

The key [did I really write this?] to the solution is the word "hash".

Do you have Adager, Ray?

If you do, I have "a" good (i.e., an "a" as in "Adager") solution for you
that will NOT "defeat Query" (and will not defeat ANY standard accessor,
in fact).

Had you attended the recent GHRUG meeting in Houston, you would have
enjoyed my mini-dissertation on the crucial difference between "the" and "a".
We missed you there.


Your "A" friend,

  _______________
 |               |
 |               |
 |            r  |  Alfredo                  http://www.adager.com                     
 |          e    |                            
 |        g      |  F. Alfredo Rego                   
 |      a        |  Manager, R & D Labs           
 |    d          |  Adager Corporation
 |  A            |  Sun Valley, Idaho 83353-3000            U.S.A.
 |               |
 |_______________|

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2