Problem:

I have a table with a numeric field defined as decimal(18).  If this field contains data with 18 digits in it I get an error message WSQL026 when I try to open the table in SQL Wizard and select record/allow editing.

Resolution:

To resolve this error you will need to make an alteration to decimal format field in the SQL for DB2 client options menu.

To do this select the options menu and then click on SQL for DB2 followed by client.

On the FORMAT tab, the DECIMAL FORMAT field will be set to -zzzzzzzzzzz9.99 (12 positions before the decimal point) as default.

If you change this to -zzzzzzzzzzzzzzzzz9.99 (18 positions before the decimal point) the update will be accepted without the error.