• Print |
• E-mail  |
• Bookmark

Executing PROC FSEDIT on an access view descriptor for DB2 Server for VM
(SQLDS) will produce the following error message.

   ERROR: DB2 VM prepare error:-205      Column column was not found in
          table creator.table. .

A minor issue is the error message does not list what column is in
error.  The real issue is the problem occurs because an incorrect list
of variables names is passed down to the database.

For example:

If a table contains the variables customer, state and firstorderdate,
rather than

   SELECT "CUSTOMER", "STATE", "FIRSTORDERDATE" ...

being passed to the database, something like the following will be
passed:

   SELECT "STATEMER", "FIRSTORD", "FIRSTORDERDATE" ...

The actual statment passed will vary per query.

There is no current workaround other than switching to the SQL passthru
facility.

A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:

http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#007855

Operating System and Release Information

A fix for Release 8.2 (TS2M0) for this issue is available at: