Re: SQL CTE in COBOL SQL statement

["Jim Essinger" <dilbernator@xxxxxxxxx>]

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.