RE: SQLRPG Help

["Alex A. Moore" <alexm@xxxxxxxxxxxxxxxx>]

There is a utility -might have come from QUSRTOOL- called FIXDECERR.  I
could send it privately if you like.

                      Fix Decimal Data Errors (FIXDECERR)

Type choices, press Enter.

File to check  . . . . . . . . .                 Name
  Library  . . . . . . . . . . .     *LIBL       Name, *LIBL
Member . . . . . . . . . . . . .   *FIRST        Name, *FIRST
List fields in error . . . . . .   *YES          *YES, *NO
Field update option  . . . . . .   *NONE         *NONE, *INZFLD, *INZDGT
Check signed decimal . . . . . .   *YES          *YES, *NO
Check packed decimal . . . . . .   *YES          *YES, *NO

Alex Moore ~ Ellis Hosiery Mills, Inc.
alexm@ellishosiery.com

                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).


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