L
ljr
I have run this same query for months with no problems. I have linked a
linked file (ODBC) which is an AS/400 file. I have chosen all the fields in
the file and the only criteria I have is to get all records with an
expiration date greater than 12/31/2005. Looks like this:
SELECT IMSLIB_ARAFF00.BNCUST, IMSLIB_ARAFF00.BNVQTE, IMSLIB_ARAFF00.BNCARR,
IMSLIB_ARAFF00.BNPSEQ, IMSLIB_ARAFF00.BNCER1, IMSLIB_ARAFF00.BNCER2,
IMSLIB_ARAFF00.BNPEFFD
FROM IMSLIB_ARAFF00
WHERE (((IMSLIB_ARAFF00.BNPEFFD)>#12/31/2006#))
ORDER BY IMSLIB_ARAFF00.BNPEFFD DESC;
When I select run, it stops the entire application. If I do not select any
criteria, it runs fine. Does anyone know if something in the date is wrong
or if there is something with the AS/400 data that is hanging me up. I do
not getting any support from our I.T. department so I would like to figure
this out without asking them.
Also, I noticed on another query I run has problems as well. I am using a
linked physical file from the AS/400 (which I have done for years), when I
started fresh with linking the file, system says "to many indexes". I can
link a logical to the file but not the physical. I did ask one of the I.T.
about that and they are telling me that they changed the file a month ago and
what they did was only add a couple of more fields to the file.
I have several applications that users run on a daily basis that use this
physical file. I have not received any calls regarding problems, so I'm just
not quite understanding why I'm now having this problem and no users are.
I appreciate any help anyone has on this....Thanks!
linked file (ODBC) which is an AS/400 file. I have chosen all the fields in
the file and the only criteria I have is to get all records with an
expiration date greater than 12/31/2005. Looks like this:
SELECT IMSLIB_ARAFF00.BNCUST, IMSLIB_ARAFF00.BNVQTE, IMSLIB_ARAFF00.BNCARR,
IMSLIB_ARAFF00.BNPSEQ, IMSLIB_ARAFF00.BNCER1, IMSLIB_ARAFF00.BNCER2,
IMSLIB_ARAFF00.BNPEFFD
FROM IMSLIB_ARAFF00
WHERE (((IMSLIB_ARAFF00.BNPEFFD)>#12/31/2006#))
ORDER BY IMSLIB_ARAFF00.BNPEFFD DESC;
When I select run, it stops the entire application. If I do not select any
criteria, it runs fine. Does anyone know if something in the date is wrong
or if there is something with the AS/400 data that is hanging me up. I do
not getting any support from our I.T. department so I would like to figure
this out without asking them.
Also, I noticed on another query I run has problems as well. I am using a
linked physical file from the AS/400 (which I have done for years), when I
started fresh with linking the file, system says "to many indexes". I can
link a logical to the file but not the physical. I did ask one of the I.T.
about that and they are telling me that they changed the file a month ago and
what they did was only add a couple of more fields to the file.
I have several applications that users run on a daily basis that use this
physical file. I have not received any calls regarding problems, so I'm just
not quite understanding why I'm now having this problem and no users are.
I appreciate any help anyone has on this....Thanks!