On Thu, May 8, 2008 at 8:08 AM, carlissi <[EMAIL PROTECTED]> wrote: > I have been given the unpleasant work of moving a database from AS400 DB2 to > a linux DB2. I am by no means a DB2 expert (perhaps DB2 user would be a > better word) and have come across a problem I can not solve. I am using > databaseToDdl to try and export the datasbase and it's content. This works > fine on the Linux DB2, but when I try it on the AS400 I get the following > error: > > [SQL0204] COLUMNS in SYSCAT type *FILE not found. > > I am not sure if the parameters I am using for databaseToDdl are correct. If > anyone has any pointers, I would be very grateful.
It looks like the AS400 DB2 version does not have the SYSCAT view. What Db2 version is it ? Also, please file a bug report in JIRA. Tom
