× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



in the place of varchar, ( date(varchar(integer(T01.IATRND/10000)) || '-'
||) use DIGITS. varchar will drop leading zeroes, a common cause of this
issue.

On Thu, Oct 13, 2016 at 9:20 AM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

I have this sql query that has been halting since 9/28/16 during the
crystal report run, it was working fine for over 2 years. The error getting
is this:

'SQL0181 Value in Date, Time, or Timestamp not valid Database vendor code
-181'
I checked against this date IATRND, via a query/400 and see nothing funky.

Is there a way to show me which particular date and order # is the problem?

SELECT
ALL
T01.IAPRT#, T01.IA101, T01.IATRND,T01.IAUSRN,T01.IAPRLC, T01.IARCC1,
T01.IATRT, T01.IARCC2, T01.IARCC3, T01.IARCC4, T01.IARCC5,
T01.IAACTF, T01.IATRNC,
T02.IABMU, T01.IARCC6, T01.IARCC7, T01.IARCC8, T01.IARCC9,
T01.IARC10, T02.IAHCD1, T02.IAHCD2, T02.IAHCD3, T01.IAPTWT,
T01.IARC11,T01.IARC12, T01.IARC13, T01.IARC14, T01.IARC15
FROM ASTDTA.AUDIA T01,
ASTDTA.ICPRTMIA T02
WHERE T01.IAPRT# = T02.IAPRT#
and date(varchar(integer(T01.IATRND/10000)) || '-' ||
varchar(integer(T01.IATRND/100) - integer(T01.IATRND/10000) *
100) || '-' ||
varchar(mod(T01.IATRND, 100))) = current date
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.