Start a new topic

db2 describe table

[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. Any solutions?

[This reply is migrated from our old forums. The original author name has been removed]

Re: db2 describe table
Thanks for updating this. I apparently missed the '@' as well with describe. 1 google search, and your answer saved me a bunch of time. Appreciate it.
[This reply is migrated from our old forums. The original author name has been removed]

Re: db2 describe table
OK, I did RTFM and found that I should use "@desc " in the commander to get the result that I need. It works.