db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Created: (DDLUTILS-206) Support DB2/AS400
Date Wed, 14 May 2008 02:47:55 GMT
Support DB2/AS400

                 Key: DDLUTILS-206
                 URL: https://issues.apache.org/jira/browse/DDLUTILS-206
             Project: DdlUtils
          Issue Type: Improvement
          Components: Core - DB2
    Affects Versions: 1.0
            Reporter: Thomas Dudziak
            Assignee: Thomas Dudziak

DB2 on AS400 currently doesn't work, it throws this error:

[SQL0204] COLUMNS in SYSCAT type *FILE not found.

This is because DdlUtils uses the SYSCAT view to determine identity columns, and this view
is not defined in AS400 (at least in v5r3).
There are ways to work around this, e.g. using the base tables as described in http://forums.devshed.com/db2-development-114/back-porting-from-db2-udb-v8-unix-to-db2-v7t-202653.html

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message