Re: Error return on SQR (DB2)

[Denise White <dewhite@VICR.COM>]

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.