Subject: | |
From: | |
Reply To: | |
Date: | Fri, 1 Sep 2000 08:35:28 -0400 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Curtis Cappell <[log in to unmask]> writes:
> I can verify and read certain records using SUPRTOOL or QUERY, but they
> can't be found using third party software such as Datanow! or SRN's IRIS.
> At first I thought it was an Omnidex indexing problem, and a recent
removal
> and reloading of the Omnidex keys seemed to temporarily fix the problem,
but
> the problem has resurfaced and has been seen in non-Omnidex enhanced IMAGE
> databases.
To add to Chris Goodey's reply:
I have had similar problems in the past (that is, I can read the record with
QUERY but not with my application) and the problem has almost always been
that the key value isn't what I think it is. For instance, an alphanumeric
key will have non-blank trailing characters in it (like an X20 field where
we are using the first ten characters and expect the remaining ten
characters to be blank). Or, my personal favorite, using a Z field for the
key and then defining it as 9's in a COBOL program (for example, a Z6 field
defined as PIC 9(6) in COBOL, when it should be S9(6)). This one is
particularly obnoxious in that a QUERY "FIND KEY = 6" will work (note the
absence of a "+" sign), but moving 6 to the key find value in a COBOL
program will not work.
Anyway, I agree with Chris:
"if I can reproduce something with Query, but not the other package, I
figure the package is broken."
HTH,
Jim Phillips Manager of Information Systems
E-Mail: [log in to unmask] Therm-O-Link, Inc.
Phone: (330) 527-2124 P. O. Box 285
Fax: (330) 527-2123 10513 Freedom Street
Web: http://www.tolwire.com Garrettsville, Ohio 44231
|
|
|