Re: SQLRPG Help

Hi Mark,

DBU (DataBase Utility) will do it. If you don't have that, it's possible
that WRKDBF will do it, but I'm not sure.

HTH
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

----- Original Message -----
From: Mark McCarty <M_McCarty@worldnet.att.net>
To: <RPG400-L@midrange.com>
Sent: Thursday, February 17, 2000 2:56 PM
Subject: SQLRPG Help


> I have a decimal data error that somehow long ago got into a field.  Is
> there a way using sql toreplace the error with a 0.  When I try a simple
> update it gives me an 802 error with type 6(data decimal).
>
> The way I am looking at is to copy all the records minus the field into
> a dummy file and place a zero
> into default zero in the bad field, update the non error fields with the
> correct values and that would leave 0 in the bad records, then cpyf back
> to the real file.
>
> Any suggestions on a simpler approach?
>
> Mark A McCarty
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---


__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---