RE: SQL7919 - SQL loads into a DS

also when using zoned numerics under the covers your RPG processing will
convert those to packed, perform your calcs, etc then convert them back to
zoned which is more CPU intensive and less efficient.


Thanks,
Tommy Holden



From: <Rick.Chevalier@xxxxxxxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Date: 08/11/2010 07:41 AM
Subject: RE: SQL7919 - SQL loads into a DS
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



Bryce,

I don't think It 'solved' anything, it just moved it to a different
location. True you don't see the messages anymore but casting your fields
in the select just forces a data conversion during the select. In the end
the data is still being converted. If you want to avoid the conversion
try defining the target fields as packed.

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Bryce Martin
Sent: Tuesday, August 10, 2010 3:18 PM
To: RPG programming on the IBM i / System i
Subject: Re: SQL7919 - SQL loads into a DS

I cast all the numeric fields on the select and it solved my issues.


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777

Privileged and Confidential. This e-mail, and any attachments there to,
is intended only for use by the addressee(s) named herein and may contain
privileged or confidential information. If you have received this e-mail
in error, please notify me immediately by a return e-mail and delete this
e-mail. You are hereby notified that any dissemination, distribution or
copying of this e-mail and/or any attachments thereto, is strictly
prohibited.