We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
Is this UniVerse or UniData ?
We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
This is in Unidata.
We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
Sounds weird that something would suddenly change behavior. Is there a possibility that you have a F1 dictionary defined in the file ITMMST and in the VOC/MD ? If so, maybe a new dictionary was created which is now being used in the retrieve.
We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
When you say F1 is defined as A20, where is it defined as A20. A UniData dictionary item would normally be 20L , 20R or 20T in attribute 5 of the dictonary item. I am presuming that whatever you using to define the field as A20 is generating a dictionary with 20L in attibutue 5.
UniData also has a rule of precedence on which dictionary item will be used if mutiple F1 exists on where UniData will check.
LIST ITMMST WITH F1 = "64"
ID1 64
Now if you change the F1 dictionary to be right justified
We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
A small note for everyone else, this difference between left and right justfied dictionaries can also have an impact when creating indexes which itself can then lead to unexpected results in a query.
We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
UST OPTIONS 22 was set to OFF! Problem solved in my current session by turning it ON. I'm not sure where this was set permanently and why it changed... but I guess that the next diagnotic path!
We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
.. Although changing UDT.OPTIONS 22 corrected the problem, it does indicate to me you may been using a different dictionary to the one you thought. Did you check the dictionary F1 in the files I suggested, as you may have been using F1 from DICT.DICT based on your description. What were in each dictionary of F1 for
a) the dict of ITMMST
b) the VOC file
c) the DICT.DICT file
We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
Please excuse me if I get lost... this is an old legacy system and I'm treading into unknown areas. :)
VOC entry for ITMMST:
ITMMST
F
ITMMST
......FLOPROGSLIVELIVE.IIBASE8D_ITMMST
DICT entry for F1
001 DItem Number
002 1
003
004 Item Number
005 20L
006 S
I am uncertain how to investigate further.
We have a very recent issue I cannot explain. This just started and will cause us some major headaches. Here is the example:
SELECT ITMMST WITH F1 = "64"
F1 is defined as A20, not numeric. I am getting 3 results:
64, 000064, and 0064.
I can see how a numeric search would give those results, but I am searching a string and need only the exact match in the results. Any idea why this would start for all users, in all databases... all of a sudden?
Raymond,
Looks like you are working on either Epicor's Avante or Infoflo. Looking at the previous posts, you might want to check the actual data records in ITMMST<1> for possible control characters or anything that looks "out of place".
Also, there could be 3 legitimate records in the file. Check the key of the records and see if you have 3 unique CPN's.
Just sharing my $0.00000000000000002 worth...
Grant W. Boice, Jr.
Principal Software Developer
Matheson Trig-Gas, Inc.
3 Mountainview Road
Warren, NJ 07059
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
