Re: Error return on SQR (DB2)

[Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>]

Hello Denise,

I followed up Peter Burton's lead that this error has to do with date to
string conversion.  I did a search and found some dates that are so
unreasonable they maybe causing problems on implicit conversion.  I'm not
entirely sure if this is causing the hiccup but it seems like a good
possibility.   07-MAY-1201 is an example of one of the date values I found,
which is obviously an error.

Since this script runs for about 5 hrs before it errors, I was hoping
someone had some insight on the nature of this message so i could focus in
on the problem most rapidly.  Thanks to all those who replied, I'll let you
know the final result.

-Alan.




                    Denise White
                    <dewhite@VICR.        To:     SQR-USERS@list.iex.net
                    COM>                  cc:
                    Sent by:              Subject:     Re: Error return on SQR 
(DB2)
                    "Discussion of
                    SQR, Brio
                    Software's
                    database
                    reporting
                    language"
                    <SQR-USERS@lis
                    t.iex.net>


                    02/15/2002
                    06:38 AM
                    Please respond
                    to sqr-users






Hi Alan,

Have you resolved this problem yet?  As it sounds like a data exception,
have
you put displays into your program so that you can determine which record
you
are getting the error on?  Then examine the data in that record to see if
anything looks strange.  That would be my first step in resolving a data
problem.  It's pretty elementary, so you may already have done it.

Denise White
Sr. Programmer/Analyst
Vicor
------------------------------

Date:    Thu, 14 Feb 2002 09:24:30 -0700
From:    Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>
Subject: Error return on SQR (DB2)

I'm running an SQR that dumps to a flat file from a rather large table.
Running on PS SQR 4.3.4 with SQRW locally  on windows NT4 client.
I'm selecting data from a MVS (DB2) database and I am getting the following
error return without the SQR abending:

(SQR 5528) SQLBase SQLXDP error 10509 in cursor 0:
   Digit of the number is too large

The table I'm selecting from has 55 columns and about 3,000,000 rows the
number date types in the table are as follows, no long char columns at all.
DECIMAL 18
DECIMAL 6
DECIMAL 10
DECIMAL 6
SMALLINT 2

Since I'm only dumping data I'm a little confused why I am getting what
seems to be a database error return, and I only get it after the SQR
returns 250,000 rows or so.

I searched for a definition on this error but I couldn't find anything that
shed any additional light.

Any thoughts?

-Alan.