[This topic is migrated from our old forums. The original author name has been removed]
I want to use "describe table X.Y" in the SQL-commander window when connected to DB2 LUW databases.
More often , I want to describe a catalog table e.g. "describe table syscat.tabauth".
I am using DBViz v 7.0.7 or 7.1.1 with DB2 v9.1 fp6 on AIX, or DB2 v9.5 fp4 on AIX, or v9.7 on Win x64 .
Always get an error [Error Code -104, SQL State 4260.
All other SQL statements that I try seem to work, only "describe table" gives an error.