Massimo, in your sql.py starting at line 295 change:
# 'id': 'ROWID NOT NULL', 'id': 'INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY', # 'reference': 'INT, FOREIGN KEY (%(field_name)s) REFERENCES % (foreign_key)s (id) ON DELETE %(on_delete_action)s', 'reference': 'INT, FOREIGN KEY (%(field_name)s) REFERENCES % (foreign_key)s ON DELETE %(on_delete_action)s', you can not use ROWID with db2/400, it is not integer field. Note that db2 ODBC SQL statements should NOT end with semicolon ';'. Denes. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---