Sorry David--I see what you're after, but I feel awkward posting a reply
in an RPG list for a question specifically addressed as COBOL in the
subject. I have cross-posted this reply to the COBOL list.

Maybe COBOL400-L (http://lists.midrange.com/mailman/listinfo/cobol400-l)
would be even more appropriate for this? I think Jim's challenge is the
problem really isn't COBOL or RPG---it's SQL, but there is no SQL or DB2
list. If Jim's in a COBOL-only shop, it wouldn't make much sense to
subscribe to an RPG mailing list.

I would agree the problem is likely to be with "Dec(BRQDVA *100,9,0)". We
routinely use common table expressions--in RPG and COBOL. I would check
the values in BRQDVA--perhaps do a modified statement with Order by
BRQDVA. You may want to do it in ascending order and descending to check
the range of values--or maybe do a max(BRQDVA) and min(BRQDVA).


---------------Original Message---------------
from: "Rob Rogerson" <rrogerson@xxxxxxxxxxxxxxxxx>
Could this statement be causing the problem?

WHERE BORR_SSN = Dec(BRQDVA *100,9,0)

Possibly BRQDVA * 100 is too big.

Snippet from the SQL Reference - Decimal scalar function:

An error is returned if the number of significant digits to the left of
the
decimal character (the whole part of the number) in string-expression is
greater than p-s.

---------------Original Message---------------
from: David Gibbs <david@xxxxxxxxxxxx>
This question would be more appropriate in RPG400-L
(http://lists.midrange.com/listinfo/rpg400-l) as it doesn't appear to
relate to WDSC usage.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.