[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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.