DB2 and DESCRIBE command

Posted on 2014-07-11
Last Modified: 2014-07-11
I have a table named ACCOUNT, and I verified its existence.

However I can not describe the table in order to verify its structure

What is wrong with the following command ?

SQL0104N  An unexpected token "ACCOUNT" was found following "DESCRIBE".
Expected tokens may include:  "OUTPUT".  SQLSTATE=42601
db2 =>
db2 =>
SQL0104N  An unexpected token "ACCOUNT;" was found following "DESCRIBE".
Expected tokens may include:  "OUTPUT".  SQLSTATE=42601

Open in new window

Question by:Anthony Lucia
    1 Comment
    LVL 45

    Accepted Solution

    Need the keyword "table"

    db2>  Describe table account


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now