RE: SQLRPG Help

Any good database editor such as WRKDBF, DBU, EZView, FileFlash, etc. will
do nicely especially if you know exactly where the bad data resides.

William K. Reger
Senior Project Manager
Levitz Furniture Corporation
Phone:  (561) 994-5114
E-mail:  breger@levitz.com <mailto:breger@levitz.com> 

                -----Original Message-----
                From:   Mark McCarty [mailto:M_McCarty@worldnet.att.net]
                Sent:   Thursday, February 17, 2000 5:57 PM
                To:     RPG400-L@midrange.com
                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
                +---
+---
| 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
+---