Re: SQL CTE in COBOL SQL statement

Hi David,

Michael is correct. This is not a COBOL or RPG question, but an embedded
SQL question. I thought I had posted to the Midrange-L list, as a lot of
SQL questions are flying there. If the volume of SQL and DB2 questions is
growing, might it be time to add that as a list of it's own?

Thank you all for your suggestions, not sure where to post a reply now. I
was wondering why embedded SQL was being picky, when running it as a stand
alone statement works great.

Jim

On 8/15/07, MichaelQuigley@xxxxxxxxxx <MichaelQuigley@xxxxxxxxxx> wrote:

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.
--
This is the Websphere Development Studio Client for iSeries (WDSCI-L)
mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.