RE: Default for Data Exception for trouble shooting.

["Phil Kestenbaum" <pkestenbaum@xxxxxxxxxxx>]

It happens upon usage.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Thursday, January 04, 2007 10:00 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Default for Data Exception for trouble shooting.

Ideally you'd define your data files with SQL's DDL instead of DDS and 
avoid the possibility of getting decimal data errors in your file in the

first place.
http://www-03.ibm.com/servers/eserver/iseries/db2/pdf/Performance_DDS_SQ
L.pdf

Failing that, you could change your input processing and do some
extensive 
MONITORing around each field to verify it's validity.

I am forgetting, does the error occur upon the READ, or, upon the usage
of 
the field in error?  The question being, will a dump tell you the record

or hasn't the data even been partially propagated yet?  If it's at first

use then the dump should be fine.

Rob Berendt