Re: Error return on SQR (DB2)

[Peter Clark <PGCLARK@VAC-ACC.GC.CA>]

Hexidecimal values other than F0 thru F9

>>> Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM> 2002/02/14 1:00:43 pm >>>
Not sure actually.  How would I determine that?
-Alan



                    Scott Eubank
                    <SEUBANK@ADVANCEAUTO        To:     SQR-USERS@list.iex.net
                    PARTS.COM>                  cc:
                    Sent by: "Discussion        Subject:     Re: Error return 
on SQR (DB2)
                    of SQR, Brio
                    Software's database
                    reporting language"
                    <SQR-USERS@list.iex.
                    net>


                    02/14/2002 09:31 AM
                    Please respond to
                    sqr-users






   Any packed Decimal data?

-----Original Message-----
From: Alan Ljungberg [mailto:Alan.Ljungberg@CNPL.ENBRIDGE.COM]
Sent: Thursday, February 14, 2002 11:25 AM
To: SQR-USERS@list.iex.net
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.