RE: Classic trap Was: Assistance With Embedded SQL

Another trap, Numeric subfields of an UnInitialised DataStructure have
blank values by default. So if the fields are not cleared/initialized at
initialization time, they lead to decimal Data Errors at calculation
time.
Simple solution : put INZ keyword on every DS that has numeric fields in
it. Or (less simple) do a clear on DS/subfield at initialization time.




Regards,



Rajesh Choudhary | Software Engineer, iSeries PDO
Manhattan Associates


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Wednesday, April 02, 2008 11:02 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Classic trap Was: Assistance With Embedded SQL

Hello,

Given the responses so far I suspect he now has a year's worth of
articles or at least the makings of a Programming for Dummies book.

Yes, I have a lot of suggestions, but don't stop if you have more to
say! Anything I can't use in this article, I'll work into some other
article later.

These suggestions are great.