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).
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
decimal character (the whole part of the number) in string-expression is
greater than p-s.
from: David Gibbs <david@xxxxxxxxxxxx>
This question would be more appropriate in RPG400-L
) as it doesn't appear to
relate to WDSC usage.
As an Amazon Associate we earn from qualifying purchases.