×
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.
I'm no pro from Dover on this stuff but stored procedures support
"overloading". Meaning you can have multiple procedures in the exact same
library - with the exact same name. What may be different is the
parameter list. Let me create a table to explain the "possible" problem.
FromDate 6A DIGITS(SDTRDJ)
ToDate 8A ' '
FromFormat 7A '*JUL'
ToFormat 7A '*YMD'
DateSep 7A '*NONE'
ErrorFlag 1A ' '
Century 2A ' '
Not sure whether DIGITS(SDTRDJ) is 6A, but I know that '*JUL' is not 7A.
Try this simple test. Change
select SDDOCO,
CVTDATE(DIGITS(SDTRDJ),' ','*JUL', '*YMD', '*NONE', ' ', ' ')
from ajdprddta/f4211
to
select SDDOCO,
CVTDATE(cast(DIGITS(SDTRDJ) as char(6)),' ','*JUL ', '*YMD ',
'*NONE ', ' ', ' ')
from ajdprddta/f4211
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
