I tried with both sqlite and postgresql and it works as expected. Are you sure you are using the last version of web2py ? exceptions and line number don't match with 1.99.4 (that is the version I tested for your sample code, the only different thing is that I don't have a DB2 instance available, sorry)
- [web2py] Update legacy table using primarykey failed Omi Chiba
- Re: [web2py] Update legacy table using primarykey fai... Richard Vézina
- [web2py] Re: Update legacy table using primarykey... Omi Chiba
- Re: [web2py] Re: Update legacy table using pr... Richard Vézina
- [web2py] Re: Update legacy table using primarykey fai... Omi Chiba
- [web2py] Re: Update legacy table using primarykey... Niphlod
- [web2py] Re: Update legacy table using primar... Omi Chiba
- [web2py] Re: Update legacy table using pr... Omi Chiba
- [web2py] Re: Update legacy table usi... Niphlod
- [web2py] Re: Update legacy table... Niphlod
- [web2py] Re: Update legacy t... Omi Chiba
- [web2py] Re: Update legacy t... Niphlod
- [web2py] Re: Update legacy t... Omi Chiba
- [web2py] Re: Update legacy t... Omi Chiba