Re: SQLRPG Help

[Jim Langston <jlangston@xxxxxxxxxxxxxxxx>]

If you find a simpler approach please let me know, I have some files
like this too!

And I think they way they "somehow long ago got into a field" is that
they were S36 flat files at one time, right?  It seems that sometimes
numbers in S36 would be written with leading spaces instead of 0's,
or that's been my observation anyway.

Regards,

JIm Langston

Mark McCarty wrote:

> 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?

+---
| 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
+---